Here's the workbook, I have created a calculated field 'Top 3' with formula
dragged it to color and assigned green to top 3 and grey to rest, when you flip between different options it should dynamically sort in descending. For that I clicked on Default Channel pill in rows > Sort > Sort Order 'Descending' > Sort by 'Field' > from drop down 'Sessions' and aggregation 'Sum'
Hope this helps.
Refer to this video
Dummy Beverage Data.twbx 737.6 KB
see the attached approach
I converted the table calc to this
then used this as a color code
to assure the bars are descending I added an rank formula as shown
it returns this
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Dummy Beverage Data_v10.2.twbx 764.6 KB