How to perform Pivot in Alteryx with same Output as Excel

[mattinoc]

I have a pivot in excel that displays both Vertical and Horizontal "Grand Total". How can I perform the same in Alteryx?

see attached Input and the Output that I want to achieve. Would appreciate any help here.

[binuacs]

@mattinoc One way of doing this with the Cross Tab tool

[Qiu]

@mattinoc 
The Cross Tab will do this and also generate the Sum for Row and Column.

We can then use the Dynamic Rename to cleanse the column names.

[Qiu · Accepted solution]

@binuacs 
OMG. so same...😁

[binuacs · Accepted solution]

@mattinoc Updated the workflow to reflect the sorting order and the color

[Qiu]

@binuacs 
Much better now. 👍

[mattinoc]

wow! I super appreciate the quick response @binuacs @Qiu . You guys are Superb! thank you, this is what i am looking for.