You can use custom calculations to show the percent of grand total, as
shown he
http://www.contextures.com/xlPivot10.html
BernzG wrote:
I am new to Pivot tables.
I have created a table successfully with totals and grand totals. All
works well.
What I am trying now to do is add a formula that calculates the % of
the Grand total for each row and column.
Help would be appreciated.
Cheers,
Bernz
--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html