So when you create a set it is just a boolean expression (In or Out) for the elements which meet (for in) or don't meet (for out) the condition of being in that set.
As such all you need is
if [Top 9 Exception Reasons] then [Exception Type]
Let me know if that doesn't do the trick
Thanks Simon, this worked like charm. Really what i was looking for.
Last thing: i know this is very tricky but suggest if there is a workaround. I am adding a pic of the viz i have created, but suggest if this can be sorted where the category "Others" comes at the bottom of the chart, i can manually do it but with the new data it will not work.
Glad it did the trick.
So with regards sorting there are several ways we could go. One way is like this (I've recreated your situation in the attached) but also created this calculation
[Top 3 Other Sorter]
IF [Top 3 Categories] THEN [Sales]
ELSE [Sales]-1000000 END
You can then use this field to sort the dimension (you may need to make the -10000000 number larger depending on your data). This way the Top 3 retailer their sort, but Other will always be last.
Nested Sort on Top N Set.twbx 1,018.1 KB