title: 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?
body: <p>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):</p>
  
  <p><a href="https://i.stack.imgur.com/eW4Au.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/eW4Au.png" alt="enter image description here"></a></p>
  
  <p>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:</p>
  
  <p><a href="https://i.stack.imgur.com/5HxO5.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/5HxO5.png" alt="enter image description here"></a></p>
  
  <p>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.</p>