Create Aging Buckets based on amounts

Question

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:

CustomerDocument NumberAmountAgeCompany A123$1,0015Company B345$9810Company C678$4546Company C789$564403Company A112$62175Company B109$10,000-32

My Goal Output:

CustomerNot Due YetAge 0-30Age 31-365Age 365+Company A

0$1,001$6210Company B$10,000$9800Company C00$45$564

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

Thanks.

binu_acs · Accepted Answer

@rkeenan125 one ay of doing this

alexnajm · Accepted Answer

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!