Excel Pivot Tables - Getting % of Total for filtered output
Posted on 2015-02-10
I have a filtered pivot table and I want to show the % of the output rows compared to the Unfiltered Total for that row.
In other words, if I am filtering on a Y or N field for field = N and I get an out of 10 and there were 90 with a Y I would like the % of the 10 versus the 100 total.
Can this be done?