3 of 3 people found this helpful
Apart from Product top filter , add all the dimension filters to context it will do the trick
How to add to context:
Right Click on Filter --> Add to Context
Want to know why it is not showing
Check tableau Order of Operations (Below image)
Hope this helps
Plz mark this answer as correct or helpful to close the thread
I would like to give you a more specific answer but I would need to see your workbook -
You can take advantage of the fact that LOD's are disaggregates that can be used in table calcs
see the attached - I just used superstore data to create this LOD
then the ranking is
and I used a filter to get the top 5
the "filtered sheet" returns this
Note the states are filtered and "included" in the rankin but are not on the canvas
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.
ranking w filters.twbx 2.5 MB
Ed, your situation seems to be solved mixing the two answers above.
In order to rank N you'll need to add all filters your dashboard use to the context.
As you see on image, context filters happen before LOD expressions.
Actually the replay about setting the filters to context worked as intended. Thank you all for your quick responses.
1 of 1 people found this helpful
If answer helps mark the answer as correct to close the thread