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.