Transpose vs. Crosstab

[Kureel]

I'm having difficulty with transpose vs. crosstab in Alteryx. The issue i am having is when I crosstab the data, the "values for new columns" section i need to have multiple values in that section. I issue is I have multiple states that i want to sum the amount coming through in the rows/columns so when I press the drop down for "value for new columns" , 'sum of state 1" , "sum of state 2", "sum of state 3" are options and I want all of those to be the column titles. Maybe i am thinking of this wrong so I tried to illustrate it in the attached excel. 

[mceleavey]

Hi @Kureel ,

Can you mock up the data to show what you're starting with and what you want it to look like? That will be easier to understand.

M.

[messi007]

@Kureel,

The best way to undrestand it is by checking Alteryx Exampls :

Cross Tab

Hope this helps !

Regards,

[atcodedog05]

Hi @Kureel 

Here is how you can do it.

Workflow:

Hope this helps : )

[Kureel]

@atcodedog05 that worked great! One last question. When I did your path, my Total got put on line 3 instead of line 5. Is there a way to re-order that?

[atcodedog05]

Hi @Kureel 

You can apply sorting so that total always comes last.Since it starts with T

Hope this helps : )

[Kureel]

@atcodedog05 what if my total says "Sum Total" so it comes before "Sum Wyoming"

[atcodedog05 · Accepted solution]

Hi @Kureel 

Create a column called order and for total set the value as 1 and others 0. This way when sorted total always comes last.

Hope this helps : )

[Kureel]

@atsumcodedog05 you're a genius. Thank you so much!

[atcodedog05]

Happy to help : ) @Kureel 

Cheers and have a nice day!