software

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: www.excelforum.com/member.php...oamp;userid=22949
View this thread: www.excelforum.com/showthread...hreadid=532140You can use custom calculations to show the percent of grand total, as
shown he

www.contextures.com/xlPivot10.html
BernzG wrote:
gt; I am new to Pivot tables.
gt;
gt; I have created a table successfully with totals and grand totals. All
gt; works well.
gt;
gt; What I am trying now to do is add a formula that calculates the % of
gt; the Grand total for each row and column.
gt;
gt; Help would be appreciated.
gt;
gt; Cheers,
gt; Bernz
gt;
gt;--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Thanks Debra - that link has solved my problem.

--
BernzG
------------------------------------------------------------------------
BernzG's Profile: www.excelforum.com/member.php...oamp;userid=22949
View this thread: www.excelforum.com/showthread...hreadid=532140You're welcome! Thanks for letting me know that it helped.

BernzG wrote:
gt; Thanks Debra - that link has solved my problem.
gt;
gt;
gt;
gt;--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html