Did you try adding your filter to context?(ADD 'Commodity' filter to context) I cannot say it solves the issue but if you did not try just give it a shot...I cannot download and check cause I am using an older version of tableau sorry for that..
1 of 1 people found this helpful
Avarind has the right idea. Add Commodity and Site to Context. This will do the filters first before the top 20 limitation in Parent Supplier. To do that, right click on Commodity and select Add to Context:
Then do the same for Site. And your results should look like this:
Aravind, yes this did the trick. I put each one of the dimensions that I wanted to filter by to context and it worked . I appreciate the help!
Barry, that worked perfectly. I liked your answer and marked it as helpful. I appreciate the help!