If you are using the dimension filter along with top N filter make sure add them to context
Check the Tableau order of operations , because top N and dimension filter don;t work together.
kindly mark this answer as helpful/correct so that it will help others
please see the attached
I replaced the top n filter with a rank and rank filter
the rank is this
and the filter is this
it will return this for CD
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.
Test (6)_v10.2.twbx 965.9 KB
This is because it's finding the overall top 5, and THEN filtering down to the country. So out of the overall top 5, only one of them appeared in Canada's top 5.
So what you need to do is go to the bar chart sheet and right click on country 1 in the filters and select add to context, your filter should then go grey:
What putting it into context does is that it pushes up ahead in the order of operations. So first it's filtering on country, THEN finding the top 5.
I've also replied to your other thread which has the same question.