Pivot Table Calculated field

M

MOE

I have a pivot table with columns for No's, Yes's and Grand Total. I would like to calculate the % of Yes's by
dividing the Yes's by the Grand total. Can someone give me an easy explanation of how to do that or a source? I have tried every thing I can think of and the directions I have found have not helped.... Thanks, Ann
 
D

Debra Dalgleish

To calculate total percent Yes, you could use the GETPIVOTDATA function
in a formula outside the pivot table. For example:

=GETPIVOTDATA("Region",$A$5,"Valid","Yes")/GETPIVOTDATA("Region",$A$5)
 
Top