Cross Tab and rank grouping

[Tony_Tiger]

Hi I'm new to Alteryx I want to do cross tab and grouping by rank.

 Current

Lane ID	Carrier	Carrier Rank	Cost	Volume	Historical Cost	New Cost
1	A	1	1.00	11	1.05	1.00
1	B	2	1.01	11	1.05	1.01
1	C	3	1.02	11	1.05	1.02
2	C	1	2.00	4	2.07	2.00
2	B	2	2.01	4	2.07	2.01
2	A	3	2.02	4	2.07	2.02

Want New Format

	Rank1	Rank1	Rank1	Rank1	Rank1	Rank2	Rank2	Rank2	Rank2	Rank2
Lane ID	Carrier	Cost	Volume	Historical Cost	New Cost	Carrier	Cost	Volume	Historical Cost	New Cost
1	A	1.00	11	1.05	1.00	B	1.01	11	1.05	1.01
2	C	2.00	4	2.07	2.00	B	2.01	4	2.07	2.01

Thank you

[JonMcMillin · Accepted solution]

Hi @Tony_Tiger ,

Within a workflow Alteryx does not support multiple levels of headers, So to achieve this I have combined both header rows.

If you are outputting this to a report, you may be able to use the reporting tools to arrange it with multi-level headers, However I do not have a lot of experience with the reporting tools, another member may be able to help out with that. However these two  posts could help you https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Column-sub-headings-in-reporting-Table... https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Sub-headers-Sub-fields-in-Reporting...

 

[Tony_Tiger]

thank you for your help! It works as I expected.