Creating Debt Ageing report using Pivot Table Sample 5 pg 83 84

Sample S

Sometimes you want to see debtors' names appear in rows on the leftmost column of the report while the age groups appear in columns on the topmost row. You can do this just by dragging the relevant buttons to the appropriate place in the Layout dialog. Drag the ACCOUNT-DEBIT button into the ROW box and drag the DEBT-AGE GROUP column into the COLUMN box. Below is a sample result:

	
	A				B				C				D				E
1
2
3	Sum of DEBIT	DEBT AGE GROUP
4	ACCOUNT DEBIT	0–30			30–60			60–90			Total
5	CUSTOMER A						1,061,054.05	189,487.16		1,250,541.51
6	CUSTOMER B		347,407.14		474,081.73		361,508.41		1,180,008.28
7	CUSTOMER C		534,256.75						456,114.78		1,050,371.53
8	CUSTOMER D		260,878.21						365,804.08		629,713.09
9	CUSTOMER E		502,142.54						541,227.39		1,043,369.93
10	CUSTOMER F		306,624.26						453,847.20		790,471.54
11	CUSTOMER G		048,535.50						639,034.79		1,487,600.29
12	Grand Total		2,089,964.40	1,535,106.00	3,007,055.69	7,432,156.17

83

Initially all unique accounts names will appear in column under ACCOUNT-DEBIT button. You have to remove non-customer names and leave only customers name. Follow these steps.

1. Click on the arrowhead on the right of the ACCOUNT-DEBIT button.

2. A list of accounts will appear.

3. Remove the check-marks on the left of non-customers names.

4. Click OK.

You should get the desired report.




84