Forum Discussion
How to filter by sum values pivot table
Hi- I am trying to figure out how to filter within my sum values final column of my pivot table. I need to look at values higher than 500 and less than 1000 only within the values and I cannot filter...
colbrawl Try this then. Some sort of hack that's not officially documented as an Excel feature I believe.
Select the cell directly to the right of the Grand Total column.
and put a filter on via the Home ribbon.
Now you will have a filter icon on every column in the pivot table.
Ha! Nice one!