Instead of selecting a column to sort a table by in a dropdown, how do I add the sorting column names in a separate column?

Question

I have a workbook where I have displayed a table where the user can view the top 3 IDs based on a column they can select from a dropdown (Measure A, Measure B, ... , Measure H):

Now, instead of this, I want to add a separate column called Sorting Criterion to the table that would store the column names with which the respective rows of the table was sorted. So, the expected output is something like this:

How do I do this? I'm open to using Tableau Prep Builder, if needed, for intermediate steps that may be too convoluted for Tableau Desktop.

Answer 1

Create a calculated field that just contains the Sort By parameter. Add this calculated field to your view.