Hi Guys,
I am very new to Alteryx, and I am trying to create a simple workflow , summarizing data, I need to add a row with total , how i can add a row total for the attached workbook.
hi @Shreeramps
Here's a solution for you.
The initial Filter and Select tools are there to remove the row and column totals from your input. Once this is done, transpose the data so it becomes a name/value pair of columns. Add a Cross Tab tool which is configured to add Column and Row totals. The Dynamic Rename then removes the "Sum_" from all the output fields, resulting in
Dan
danilang
Hi Danilang, Thank you for this solution for total rows and columns but it is strange that in rows total I am not getting the "Total" label instead i am getting NULL. when I download your workflow and it is working, very strange. when I copy the same workflow into another new workflow then again I am getting NULL instead Total label.
Would really appreciate your help!
Hi @Raj28
This alternate solution might help. Please check it might work for you.
Please use the attached CREW macro.
It will help to get the Total easily. Just select the columns and select the option.
Let me know if you have further more questions....
