Pivot Table Formula using Grand Totals
 

Hi;

I have a pivot table which looks like this

#1 #2 %#2/#1 %#2/Grand Total(#1)
(Age Class)
< 20 10 2 %20
21 - 25 15 4 %26.6
26 - 30 12 6 %50
31 - 35 17 1 % 5.9
36 - 40 25 12 %48
40 3 1 %33.3
----------- --- --- -----
Grand Total 82 26 %31.7


I am having difficulty to calculate the forth column (%#2/Grand
Total(#1)). I know I could create a formula that divides #2 by 82 but
the Age Class column maybe replaced by other columns which have more
rows. Therefore, hardcoding 82 wouldn't help. That's why I need the
Pivot Table to handle that calulation.

Any help would be much appreciated.

Thanks