Hi, Is there a method I can call to execute code when I click on a field in a pivot table also being able to know exactly what is the hierarchy of the fields and items. I need to add adjustment amounts to a pivottable interactively. Thank you...