Hey - I am trying to parse a pivot table to understand changes in the data source. I have a couple questions:
Is there a way to tell if a user applied a selection to the column label choices that would filter out a column ?
Also is there a way to understand what cells/data source is affecting a given value in a pivot table? So if a value changes - do we have an easy way to see all the data source cells that are driving that value?