Thanks Venu. Unfortunately I don't understand how that applies to my situation since that other poster did not have a parameter, filters, or a "rest of" category for users to interact with.
I emailed Tableau with my issue and they said I needed to use nested sorting:
"In order to effectively use nested sorting in the views as desired, two calculated fields are needed. The first calculated field sorts on the 'Trade Value (US$)' field per the first requirement of the sort and looks like:
if year([YEAR]) = 2014 then [Trade Value (US$)] else 0 END
The second calculated field ensures that the 'Rest of Countries' fields are always at the top of their bars. The second calculated field could be written like this:
if [Subset Labels (Countries)] = "Rest of world" then -1 ELSE [Trade Value (US$)] END"
I understand how to create these calculated fields. But I do not know how to use those fields for the nested sorting. If someone could explain exactly what I need to do -- step by step -- I would be very thankful, because this is a type of chart I'd like to make frequently but I keep getting stuck at the final sorting step.
Were you able to figure out how to use the calculated field. I also have a similar requirement. I need to sort the bars in descending order and keep the others group, in the end, irrespective of its value.