Create An Aging Report with Two Values in the Crosstab Query

[koolwaters]

I am trying to create an aging report that gives the sum of transactions by customer as well as the number of transactions between 0-30 Days 31-60 days 61-90 days and over 90 days.

I am able to create a crosstab query which gives the sum of transactions by customer for the different bands but am unable to get the count of transactions.

Can anyone suggest how to accomplish this? My finished report should look similar to the format below.

Excel 2010
	A	B	C	D	E	F	G	H	I
1		0-30 Days		31-60 Days		61-90 Days		> 90 Days
2		# of Transactions	Revenue	# of Transactions	Revenue	# of Transactions	Revenue	# of Transactions	Revenue
3	Customer 1	6	25,000.00	4	68,000.00	1	85,000.00	16	173,854.00
4	Customer 2	4	68,000.00	1	85,000.00	16	173,854.00	6	25,000.00
5	Customer 3	16	173,854.00	6	25,000.00	4	68,000.00	1	85,000.00
Sheet1

Thanks for any assistance.

Cheers!

 

[xenou]

Okay. Great!