A specific answer may depend on the structure of the data source and view. Are you able to share the workbook or a workbook with sample data with a similar structure?
I'm not sure if I fully understand the question and I couldn't find the example workbook. With that said, we might be able to use Rank. See the steps below.
1. Create a calculated field with the formula Rank(Sum([Measure]))
2. Drag the rank field to the Rows (or Columns shelf).
3. Right-click on the Rank field on the Rows/Columns shelf > Discrete
4. Drag the Rank field to the far left of the dimension to sort on the Rows/Columns shelf.
5. Right-click on the Rank field on the Rows/Columns shelf > de-select 'Show Header'
Hope it helps. If it doesn't, try to upload the sample workbook again.
Thanks for replying back. I got busy in some other work. Please see the attached sample workbook with my attempt so far. Is there any possible way to do this sorting dynamically like without the user have to change the parameters. Because that's what my requirement is as the data source is an excel file and data gets updated every month. So every time it gets updated , I want everything to sort dynamically on any particular "Sort_By" field.
DynamicSort.twbx 1.3 MB