Overall total for column regardless if selected or not.

B

bdaoust

I have a pivot that counts the rows matching DBO/OE or IDI. Then for
those counts, I have it broken out by producer type.

So in my pivot, I have DBO/OE and IDI in the column area and producer
type in the row area and ofcourse the sum of DBO/OE and IDI as the
data.

Now there are many producer types, but the user may select just to view
two. How can I show a percentage of the ones they are viewing
(checked) against the total of producer types regardless if they are
checked or not.

TIA
Brian
 
D

Debra Dalgleish

You could create another pivot table, on a hidden worksheet, and show
all the producer types in that table.

Then, on the first sheet, use GETPIVOTDATA formulas outside the pivot
table to calculate the percentage. For example:

=GETPIVOTDATA("Units",$B$5)/GETPIVOTDATA("Units",Sheet2!$B$4)
 
Top