Create Aging Buckets based on amounts

[rkeenan125]

Hi all,

I made a previous post but realized I didn't lay out the information properly. I am trying to create a table showing four columns of aging buckets and in each it shows the total amount of the document per customer.

My Sample Input:

Customer	Document Number	Amount	Age
Company A	123	$1,001	5
Company B	345	$98	10
Company C	678	$45	46
Company C	789	$564	403
Company A	112	$621	75
Company B	109	$10,000	-32

My Goal Output:

Customer	Not Due Yet	Age 0-30	Age 31-365	Age 365+
Company A	0	$1,001	$621	0
Company B	$10,000	$98	0	0
Company C	0	0	$45	$564

Any input is appreciated! I may also add a column to total up the rows as well.

Thanks.

[binuacs · Accepted solution]

@rkeenan125 one ay of doing this

[alexnajm · Accepted solution]

Sounds like a Tile tool with the Manual option to manually set your buckets, which will create Tile Numbers which are your groups. Based off of those numbers, you can Cross Tab to get the Tile Number into headers. Lastly you can rename the headers to fit in with your actual names!