Pivot Table: showing data as % of subtotal

K

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top