I'm hoping someone can assist me with an IntervalMatch query i have... I'm not sure if this is even possible, but would just like someone to look into it.
Basically, I have a report layout where i use IntervalMatch to sum a range of accounts. This works fine if each of my lines uses a separate set of accounts, however, i need the report to sometimes show the same account on multiple lines..
In the attached example, I want 3 lines on my report "1* accounts", "2* accounts" and lastly, "account 1001".
so I can get the first two lines, however because the last account falls into the interval "1* accounts", i cannot see it on the report... I'm not sure if i need to create a new/second IntervalMatch, or concatenate the two reports..
