Hi,
May I ask if I can build the workflow in Alteryx to get the attached pivot table results in Alteryx?
Data Set
Customer | Product | Month | Billed Local Currency | Billed USD |
A | Tier 1 | May-20 | 2,000 | 667 |
B | Tier 2 | May-20 | 2,500 | 833 |
C | Tier 3 | May-20 | 800 | 267 |
A | Tier 2 | Jun-20 | 6,000 | 2,000 |
B | Tier 3 | Jun-20 | 500 | 167 |
C | Tier 3 | Jun-20 | 7,000 | 2,333 |
A | Tier 1 | Jul-20 | 500 | 167 |
B | Tier 1 | Jul-20 | 7,800 | 2,600 |
C | Tier 3 | Jul-20 | 6,000 | 2,000 |
Pivot Table (see attached)
Many Thanks!
Regards,
Sylvia
Solved! Go to Solution.
Hi @sylvia726,
Something like this? You can't have merged headers in Alteryx, unless you use the text and table tools in the Reporting tool palette.
HI David,
Really thanks for your response. It works and looks very good to me.
Regards,
Sylvia