Cross Tab and rank grouping

Question

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

Current

Lane IDCarrierCarrier RankCostVolumeHistorical CostNew Cost1A11.00111.051.001B21.01111.051.011C31.02111.051.022C12.0042.072.002B22.0142.072.012A32.0242.072.02

Want New Format

Rank1Rank1Rank1Rank1Rank1Rank2Rank2Rank2Rank2Rank2Lane IDCarrierCostVolumeHistorical CostNew CostCarrierCostVolumeHistorical CostNew Cost1A1.00111.051.00B1.01111.051.012C2.0042.072.00B2.0142.072.01

Thank you

JonMcMillin · Accepted Answer

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-tool/td-p/98 https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Sub-headers-Sub-fields-in-Reporting-Tables/ta-p/20367