Percentage calculation in pivot table

[Guest]

Hi there

I need to get the % of totals in the pivot table and don't know the formula
to use when using the Insert calculated field option in the pivot table.

Can someone assist

 

[Roger Govier]

Hi Amanda

Right click on a cell in your PT. Select PT Wizard>Layout.
Double click on the relevant data field and select Options. As you
scroll down you will see there are options to express the value as % of
different things.
If you want both the absolute and the percentage, drag the filed to the
data area twice, setting 1 to Sum or Count as required, and the other to
the percentage option.

 

[Epinn]

Roger,

This is great. For other calculations, we probably need to add a calculated field.

http://www.datapigtechnologies.com/flashfiles/pivot4.html

But for percentages, I'll definitely use the built-in feature. As a matter of fact, I have a problem using calculated field feature to calculate percentages because the grand total isn't a field for me to insert. I won't worry about it.

It took me a few attempts to get the Options button. At first, I clicked on the data field towards the right (outside the box) and the Options button never showed up. I had to click on the data field *in the data area* in order to have the Options button.

By the way, thanks for telling us about the DataPig web site. I like it a lot.

Epinn

Hi Amanda

Right click on a cell in your PT. Select PT Wizard>Layout.
Double click on the relevant data field and select Options. As you
scroll down you will see there are options to express the value as % of
different things.
If you want both the absolute and the percentage, drag the filed to the
data area twice, setting 1 to Sum or Count as required, and the other to
the percentage option.

 

[Guest]

Thank you Roger - it's working
Amanda

Roger,

This is great. For other calculations, we probably need to add a calculated field.

http://www.datapigtechnologies.com/flashfiles/pivot4.html

But for percentages, I'll definitely use the built-in feature. As a matter of fact, I have a problem using calculated field feature to calculate percentages because the grand total isn't a field for me to insert. I won't worry about it.


It took me a few attempts to get the Options button. At first, I clicked on the data field towards the right (outside the box) and the Options button never showed up. I had to click on the data field *in the data area* in order to have the Options button.

By the way, thanks for telling us about the DataPig web site. I like it a lot.

Epinn

Hi Amanda

Right click on a cell in your PT. Select PT Wizard>Layout.
Double click on the relevant data field and select Options. As you
scroll down you will see there are options to express the value as % of
different things.
If you want both the absolute and the percentage, drag the filed to the
data area twice, setting 1 to Sum or Count as required, and the other to
the percentage option.