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.
@binu_acs OMG. so same...😁
@mattinoc Updated the workflow to reflect the sorting order and the color
@mattinoc One way of doing this with the Cross Tab tool
@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.
@binu_acs Much better now. 👍
wow! I super appreciate the quick response @binu_acs @Qiu . You guys are Superb! thank you, this is what i am looking for.
