GPSPOW
asked on
Excel Pivot Tables - Getting % of Total for filtered output
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?
Thanks
glen
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?
Thanks
glen
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER