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 |
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.