View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
PJS
 
Posts: n/a
Default Pivot Table (displaying data as a percentage)

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