Hi,
I am trying to create a grouping for two levels of grouping for a set of data. I tried to utilize the cross tab node to perform this but I was only able to group at one level at a time.
Data Input:
Group | Sub-Group | Account | Value |
A | 1 | 100 | 5 |
A | 2 | 100 | 10 |
A | 2 | 100 | 15 |
B | 1 | 100 | 10 |
Desired Data Output:
A | A | A | B | B | |
1 | 2 | Total | 1 | Total | |
100 | 5 | 25 | 30 | 10 | 10 |
Any help would be greatly appreciated!
Solved! Go to Solution.
Hey Paul,
I really appreciate that and it seems like it definitely solves the issue I was having, but I have one followup. This may not be possible, but would it be possible to have the two levels like A for the first column being "A" and then the next row below being "1", not being "A_1" in the header. Its not a big deal if its not possible, but wanted to ask.
Not in a table that I'm aware off. But in a report you can. So the output would have those levels.