Excel – Filter the Grand Total of a Pivot Table

microsoft excelmicrosoft-excel-2010pivot table

I am tracking a daily compliance percentage for activities. I want to trend the monthly average compliance for the 10 tests with the lowest compliance total. I am having issues trying to figure out the best way to do this since I am unable to filter by the grand total. Attached is a picture of what the pivot table looks like.

enter image description here

enter image description here

Best Answer

I ended up creating a new table (beside the pivot) that is indexed by cell so even if the order of the pivot changes, the top 20 rows will be what is copied over. Then I created the chart from the new table. Thanks for helping!

enter image description here

Related Question