Dynamically Sort Descending on Last Column and Add Rank Column

[ShaneGraham]

I need to sort on the last column of input, which is dynamically created based on a crosstab. Playing around I can identify the column name of the last column easily enough, but couldn't quite figure out how to sort on it.  Also I need to add a Rank column and make it the last column.  Please see attached sample input and workflow.  Thanks.

[jdunkerley79 · Accepted solution]

Two ways occur to me (both use a FieldInfo tool to get name of last column):

1. Transpose and keep just the last column then use this to rank the results before joining back.

2. Sneakier... Rename the last column, sort and rank, and then rename back

Sample of both attached

I expect the second method to be a huge amount faster on a large scale

[ShaneGraham]

Thank you for the quick solution.