Dear Member,
I am facing a problem in Quicksight, lets assume we have three filters in sheet ( Zonal head, Manager and store), when we select one zonal head (A) so ideally data in others filters should reflect accordingly) , right now if I select a manager from filter still in other filter (store) I can see all store name , but i want only those stores which are mapped to that manager only.
could you please help on this?
Hello,
You can achieve this using “cascading filters”. See the description and how to configure it in this link:
Thank you,
Not sure about using just a regular filter but at least when using parameter controls there is an option in the parameter setting called Show Relevant Values Only. You can then select what other control factors into this. This should accomplish what you’re going for I believe
