Pivot Table - creating % of Totals
 

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


--
BernzG
------------------------------------------------------------------------
BernzG's Profile: http://www.excelforum.com/member.php...o&userid=22949
View this thread: http://www.excelforum.com/showthread...hreadid=532140

Pivot Table - creating % of Totals
 

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

Pivot Table - creating % of Totals
 

Thanks Debra - that link has solved my problem.

:)


--
BernzG
------------------------------------------------------------------------
BernzG's Profile: http://www.excelforum.com/member.php...o&userid=22949
View this thread: http://www.excelforum.com/showthread...hreadid=532140

Pivot Table - creating % of Totals
 

You're welcome! Thanks for letting me know that it helped.

BernzG wrote:
Thanks Debra - that link has solved my problem.

:)




--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html