Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Need to aggregate monthly sales columns into one total sales column

Patti
5 - Atom

Help! I am stuck. I have rows with monthly sales grouped by city but I want to group the sales by total sales for each city. I have tried the transpose then summarize tool but it doesn't appear to be working for me! Help!

3 REPLIES 3
Qiu
21 - Polaris
21 - Polaris

@Patti 
Can we have some sample input and output data?

It seems to me that your first transpose is not configured correctly.

 

Patti
5 - Atom

Images are attached, Yes I think my first transpose is wrong. Can you help?

Patti
5 - Atom

I just worked it out! haha

Labels