Transpose vs. Crosstab

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.

Book1.xlsx

Workflow

Datasets

Input

Transformation

Accepted answers

atcodedog05

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 : )

All comments

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.

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 : )

rotate.yxmd

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?