Using Cross Tab for 2 Levels of Grouping

[eschm0309]

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!

[paulfound · Accepted solution]

Hi @eschm0309 

This is my idea for the solution.

Hope it works let me know.

[eschm0309]

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.

[paulfound]

Not in a table that I'm aware off. But in a report you can. So the output would have those levels.