Hi,
How can I use alteryx to summarize a tableau with 150 columns?
I have account number down on the "y-share" in my table and a 150 company names on the "x-share". I want to summarize all the different amounts for each company on each account number.
Ex
Account number | Comapny 1 | company 2 |
12000 | 1,000 | 2,000| = 3,000
12100 |1,000 | 2,000| = 3,000
I have tried to use transpose but it want work. Could someone please help me?
Solved! Go to Solution.
Hey
It sounds like "Summarize Tool" with following setup:
1) Group by - Account Number
2) Sum of respective columns containing companies.
Like so:
@Lerk
find the workflow attached
made this dynamic for n number of columns
Mark done if solved.