I have this table with accounts id :
and i want to achieve something like this
I did it in the wrong way, because there’s more levels than i expected, as many as GroupingCategory is like “GA”. And “GA” can have 3 digits, or 4 or 5. “GR” has always 2 digits and GM is movements.
I’m attaching an excel file for you tom take a look and try to help me better.
1 more thing, please notice that this file is missing the groupingCode with 1 digit in all accounts.
Thank you all
PedroDNA Paths.xlsx (10.0 KB)