Pivot Table: showing data as % of subtotal

[kg]

Hi,

I have pivot table data in this format:

Name Type Amount
ABC 1 $100
2 $200
3 $300
4 $400
ABC Total $1,000

DEF 1 $150
2 $260
3 $310
4 $420
DEF Total $1,140

and so on
....
....
....

I want to see the data as follows:

Name Type Amount %
ABC 1 $100 10
2 $200 20
3 $300 30
4 $400 40
ABC Total $1,000 100

....
....
....

Please help me... kindly reply to my mesg personally.

 

[Debra Dalgleish]

There's no calculation to show percent of subtotal. Perhaps you could
put Type in the column area. Then, add a second copy of Amount to the
data area, and change it to % of Column, as shown here:

http://www.contextures.com/xlPivot10.html