cgmojoco
Well-known Member
- Joined
- Jan 15, 2005
- Messages
- 699
Hi there-
I have a pivot table on the left hand side of my worksheet
I have columns to the right of that pivot table that I use to add comments to data in the pivot table.
How can I apply an autofilter to the pivot table so that when I change the row criteria in the pivot table the data in the columns to the right of the pivot table sort/hide/show along with the pivot table?
I've seen settings where an autofilter is applied to the pivot table, but I cannot figure out how to do that...
I have a pivot table on the left hand side of my worksheet
I have columns to the right of that pivot table that I use to add comments to data in the pivot table.
How can I apply an autofilter to the pivot table so that when I change the row criteria in the pivot table the data in the columns to the right of the pivot table sort/hide/show along with the pivot table?
I've seen settings where an autofilter is applied to the pivot table, but I cannot figure out how to do that...