I have marked this question as 'Assumed Answered' by mistake. Can you please make it as 'Unanswered'. Apologies for the inconvenience.
No problem, let's make your question
Assumed Answered indeed :-)
Which dimensions do you need to be sorted
(by the Sum of Net Exposure in desc order)?
Country only, VIR only or a combination of both?
I assume the latter -- that's why you've created
a Country & VIR (Combined) field, I suppose.
The next logical step is to place the combo pill on Rows.
An alternative to the Combo approach would be
a Table Calculation discrete sorting pill based on
RANK() or INDEX() functions, as shown here:
Please find the attached (version 9.3) workbook
as an example of both. Hope it helps.
Sort_YF.twbx 1.2 MB
I would like to sort only the sum of Net Exposure by descending order. Apologies that I wasnt clear in my original post.
Attaching a sample twbx file which I just created using RANK(SUM(NET EXPOSURE). I am expecting the result to appear in the below order, which is not coming out as expected in my attachment.
Sample.twbx 15.8 KB
Yes.. Awesome. Thank you so much Yuriy.
Ramkumar, you're welcome.