How do I create a pivot using crosstab in Alteryx

iamkamara_jpm

Trying to create the below pivot in Alteryx

Basically, I want things grouped by Sports type, where the mens and womens games are under their respective pillars like below and then the revenue attached to each

Sports	Type	Revenue
Tennis	Mens Game	84,574,854.00
	Womens Game	34,843,854.00
Soccer	Mens Game	37,478,343.00
	Womens Game	4,758,475,474.00

cjaneczko

Can you provide an example of your RAW data set? It looks like you want to use a Summarize tool and not a crosstab. In the summarize tool you would Groupby Sports and Type and sum up the Revenue. But you will have the Sport repeating without the blank. To add a blank in there you would likely need to use a MultiRow formula to update and remove the duplicate name.