Pivot Tables: Filtered PT Showing "% of total" unfiltered data
Say that I run a pivot table and use the filter to filter the data. For example, I have a data set of school children and I filter to see just performance info on red headed children.
As you know, in excel 2007 and up you can display the values in a PT as % of...
What I'd like to do, and don't see a way how to, is to show the values inside the PT as % of the total unfiltered performance of all school children.
Is there a way to do that? (preferably, without adding columns to the PT)
Thanks in advance!
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Tags for this Thread
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1