Hi, I am new to Alteryx and would like to do the following summation but not sure how to use cross tab tool with multiple columns - can anyone assist? Thank you
Country | ID | code 1 | % | code 2 | % |
X | 1 | A | 100% | - | - |
X | 2 | B | 0% | D | 100% |
X | 3 | D | 80% | A | 20% |
X | 4 | B | 70% | D | 30% |
X | 5 | A | 20% | B | 80% |
To new format as below | |||||
Code | ID | ||||
A | 140% | ||||
B | 150% | ||||
C | 0 | ||||
D | 210% |
Solved! Go to Solution.
Great thank you!