Reversing the columns values in Alteryx - making it dynamic

[Anirudh_A]

Hi, 

What's the most efficient way to dynamically reverse the numbering count of column in a new column for different groups?

I have this - 

Number	Values	Group
1	1%	X
2	2%	X
3	6%	X
4	7%	X
1	4%	Y
2	3%	Y
3	2%	Y
4	10%	Y

Want this - 

Number	Values	Group	NEW
1	1%	X	4
2	2%	X	3
3	6%	X	2
4	7%	X	1
1	4%	Y	4
2	3%	Y	3
3	2%	Y	2
4	10%	Y	1

Can this be dynamically adjusted, so if the MAX of Number column in 10, the NEW column starts to reverse the count from 10 - without changing the order of the original data

Any help is appreciated

[suwenchuan]

Hi, my take on this

[Amy_smart]

Hi, You could also use the formula tool.

[flying008]

Hi, @Anirudh_A 

Another way by dynamic solution for you:

[sparksun]

Here is my way,if the Maximum number is 10, just change 5 to 11.

[caltang]

Hi @Anirudh_A - it's been some time since you last posted. Did any of the above solve your need? If yes, kindly mark them as accepted solutions to close the thread.

Thanks!

[grazitti_sapna]

Hi @Anirudh_A 

Adding a Tile tool with summarize in workflow will give you required output dynamically. You can refer attached workflow.

Thanks