Hello all,

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!