Pivot Table - creating % of Totals

[BernzG]

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]

You can use custom calculations to show the percent of grand total, as
shown here:

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

[BernzG]

Thanks Debra - that link has solved my problem.

[Debra Dalgleish]

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