Creating Debt Ageing report using Pivot Table Sample 2 pg 80

This report shows each custome name in a age group :

	A					B						C
1
2
3	Sum of RM–DEBIT
4	DEBT AGE GROUP		ACCOUNT–DEBIT			Total
5	0–30				CUSTOMER B				347,467.14
6						CUSTOMER C				594,256.75
7						CUSTOMER D				260,878.21
8						CUSTOMER E				502,142 54
9						CUSTOMER F				336,624.26
10						CUSTOMER G				848,595 60
11	0-30 				Total					2,889,964 40
12 	30-60				CUSTOMER A				1,061,054 35
13						CUSTOMER B				474,081 73
14						SUBSIDIARY A			420,059.60
15	30-60 				Total					1,955,195.68
16	60-90				CUSTOMER A				189,487 16
17						CUSTOMER B				361,509 41
18						CUSTOMER C				456,114 78
19						CUSTOMER D				365,834 88
20						CUSTOMER E				541,227 39
21						CUSTOMER F				453.847 28
22						CUSTOMER G				639,034 79
23						SUBSIDIARY A			141,561.40
24 	60-90 				Total					3,148,617 09
25 	90-120				SUBSIDIARY A			89,296 20
26 	90-120 				Total					89,296 20

Here are the steps to build the report:

1. Follow the steps 1 to 13 from Sample 1.

2. Drag the button DEBT-AGE GROUP (partly hidden) into the ROW box. Drag the button ACCOUNT-DEBIT into the ROW box but below the DEBT AGE GROUP button, and drop it there. Drag the button RM-DEBIT into the DATA box.

3. Follow the steps 15 to 17 from Sample 1.

4. You should get the above report.

80