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.