Hi,

Currently, I have a pivot table that looks like this

Description (Plan 1)

A 133
B 5,870
C 669
D 526

GrandTotal 7,198

The pivot table is to display Plan 1 results only.
However, plan 1 contain products A through D.
Instead of displaying the numbers as above, is it possible to display a
percentage?

(Here is what I like to see)

Description (Plan 1)

A 2%
B 82%
C 9%
D 7%

GrandTotal 100%

Thank you =D

You need to first insert a Calculated field which is the same as the value
field.

then right click on the name of the field and click on the field settings.

Click on the options button. In the "show data as" dropdown box select the
option " % to total"


Hope this meets your requirements. Let me know if you could not.




"PJS" wrote:

Hi,

Currently, I have a pivot table that looks like this

Description (Plan 1)

A 133
B 5,870
C 669
D 526

GrandTotal 7,198

The pivot table is to display Plan 1 results only.
However, plan 1 contain products A through D.
Instead of displaying the numbers as above, is it possible to display a
percentage?

(Here is what I like to see)

Description (Plan 1)

A 2%
B 82%
C 9%
D 7%

GrandTotal 100%

Thank you =D

Thank you very much!


"Manoj" wrote:

You need to first insert a Calculated field which is the same as the value
field.

then right click on the name of the field and click on the field settings.

Click on the options button. In the "show data as" dropdown box select the
option " % to total"


Hope this meets your requirements. Let me know if you could not.




"PJS" wrote:

Hi,

Currently, I have a pivot table that looks like this

Description (Plan 1)

A 133
B 5,870
C 669
D 526

GrandTotal 7,198

The pivot table is to display Plan 1 results only.
However, plan 1 contain products A through D.
Instead of displaying the numbers as above, is it possible to display a
percentage?

(Here is what I like to see)

Description (Plan 1)

A 2%
B 82%
C 9%
D 7%

GrandTotal 100%

Thank you =D