How do I calculate percentages in a pivot table?

G

Guest

I created a pivot table showing aged receivables by branch and category. I
want to show what % each aging period is of the total AR for that category in
that branch.

Branch Cat Total AR Current % 31-60 % 61-90 % >90 %
A 1 100 50 ? 30 ? 10 ?
10 ?
2 300 200 ? 120 ? 40 ?
40 ?
B 1 200 100 ? 60 ? 20 ?
20 ?
2 300 200 ? 120 ? 40 ?
40 ?

Question marks indicate where I want the percentages to calculate.

Any suggestions?????
 

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

Excel 2002: How to add without splitting blocks ? 3
Pivot Table lookup 1
Pivot Table: showing data as % of subtotal 1
Basic question - how to calculate a cumulative percentage 2
How do I perform extended calculations in a Pivot Table in Excel 2 4
Consolidate Pivot table from multiple files 4
PivotTable Grand Totals By Item 4
How to create percentages for the combined rows? 1

Top