Hi team Alteryx,
Firstly, I apologise if this topic has been covered elsewhere but I wasn't able to find a solution that worked.
I'm trying to get this:
To become this:
Essentially, what this is doing is creating a cross-tab of the NUMBER column, providing a sum of the values for each GROUP, then calculating the total and average and tacking them on the end.
Trouble is, the number columns change depending on a filter (not shown) applied higher up in the workflow. I can end up with up to 12 number columns and it can even skip numbers. At the moment, I am achieving the desired output by using a summarise tool, but because it doesn't allow for dynamic selection of columns, I have to configure it each time I change the filter.
This is the workflow as it currently exists:
I've put the containers around where dynamic column selection is required.
The formula multiplies the value in the column by the column number, which at the moment is very manual.
I'm looking for a way of achieving the same result without having to configure both these tools.
I've attached a copy of the workflow above and the sample data.
I'd really appreciate the help.
Oh and I love the add total CReW macro.
I'm using Alteryx Designer v2020.1.5
Many thanks,
Amanda.
