Hi,
I have had a decent google and haven't managed to find an answer that suits my problem.
I have created a pivot table with 2 columns of data (as an example).
I have added a subtotal to the row of data which is just summing the row label.
Like this example for a debtors report:
Row Label: Balance 30 Days Balance 60 Days Balance Total
Customer (subtotal) $500 $250 $750
Cust A $100 $50 $150
Cust B $200 $100 $300
Cust C $200 $100 $300
But I need to add another subtotal under the summed one, which shows percentage of the balance total. Like this:
Customer (subtotal) 66.6% 33.4% 100%
Can this be done as part of the pivot table?
(am using Excel 2010)
Thanks
I have had a decent google and haven't managed to find an answer that suits my problem.
I have created a pivot table with 2 columns of data (as an example).
I have added a subtotal to the row of data which is just summing the row label.
Like this example for a debtors report:
Row Label: Balance 30 Days Balance 60 Days Balance Total
Customer (subtotal) $500 $250 $750
Cust A $100 $50 $150
Cust B $200 $100 $300
Cust C $200 $100 $300
But I need to add another subtotal under the summed one, which shows percentage of the balance total. Like this:
Customer (subtotal) 66.6% 33.4% 100%
Can this be done as part of the pivot table?
(am using Excel 2010)
Thanks
