When the table calculation concerned, the setting becomes very complicated which is the big headache of Tableau.
In you case, to make sort correctly under the filter,
1. calculate LOD sum value.
2. make filters to context.
Slider Filter is available with "Continuous"
Set index filter as discrete. and same tablea calc setting.
exclude_topN_bottomN_SM_10.2.twbx 393.9 KB
Thank you very much for taking the time to deliver this solution, it works well!
You are very welcome.
Do you know how I might extend this solution by applying the slider filter to multiple worksheets from a dashboard? This solution might be a no go for my use case given that I can't find a way to either:
- collapse a slider bar in the dashboard if no data in the worksheet
- use one filter slider bar to control the "index" dimension you used for multiple worksheets
I am open to alternative solutions if this solves my original problem.