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: GroupSub-GroupAccountValueA11005A210010A210015B110010 Desired Data Output: AAABB 12Total1Total100525301010 Any help would be greatly appreciated!

Using Cross Tab for 2 Levels of Grouping

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!

Workflow

Tips and Tricks

Accepted answers

paulfound

Hi @eschm0309

This is my idea for the solution.

Hope it works let me know.

2 Levels of Grouping.yxmd

All comments

paulfound

Hi @eschm0309

This is my idea for the solution.

Hope it works let me know.

2 Levels of Grouping.yxmd

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.

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

Hollingsworth 335

LanisC 335