Do you feel that you are Tableau Expert? Then try this challenge 9

Here I am coming with real time challenge. Those who are interested can try this and test your knowledge.

Image 1

Image 2

Image 3

You can observe the above 3 images you will understand the challenge here.

I am showing report with category and Sum(Sales). User will select Dimension name from the “select dimension parameter”. Based on user selection, in next filter the values of that dimension will show. 

For example see Image 1:
User selected region in “Select Dimension parameter”. Below to that parameter, user can able to see the Region dimension values.

Similarly for the Segment dimension also.

Now the challenge is how you will show Top 5 Product names by Sum(sales) in filter, when user selects “Top 5 Products by Sales” in Select dimension Parameter. If you perfectly archive this challenge, Numbers in 3 images should exactly match with your numbers. Use data set attached below this post.

Note: This challenge is implemented in a single sheet. I did not used dashboard or multiple sheets to get this challenge.