Hi all,
Is there a way to group data by one column's values, and then have another one (or two) columns sort in ascending order then start the sort over when a certain value is reached in the second column?
For example, I want to have issue age grouped by age, and then I want to have duration and issue age sorted in ascending order. Once attained age reaches its highest value (120) I want the loop to start over.
Issue Age | Duration | Attained Age |
59 | 1 | 59 |
59 | 2 | 60 |
59 | 3 | 61 |
59 | 4 | 62 |
59 | 5 | 63 |
. | . | . |
. | . | . |
. | . | . |
59 | 62 | 120 |
60 | 0 | 60 |
60 | 1 | 61 |
60 | 2 | 62 |
I've tried a few things with summarize tools, multi-row formulas, sorting tools, etc. and haven't been able to figure it out.
Thanks!
Solved! Go to Solution.
HI,
Have you tried 3 group by to verify the result?
[]
@JordanJ Attached is the workflow. I just sorted by issue age, duration and attained age then use the unique tool to get rid of duplicates ending with the multi-row formula tool to get the counter. Is this what you are looking for?
Thanks @DiganP, that worked perfectly!