I created a formula to calculate the aging of a set of data - how old an invoice is. Now I want to take the data and group by a range of this aging to output my data summary.
In other words, I want to create a table that shows how many of each category or exception reason I have that are between 0 and 10 days, 11-30 days, 31-60 days, 61-90 days, 91-120 days, and over 120 days.
Solved! Go to Solution.
@rdlouviere can you upload the input file?
@rdlouviere Are you looking for something like below