hi @jotg , Yes we can achieve this by using the concepts in QuickSight like Cascading Filter.
It means When you select one filter value then the other filter value is auto select.
Please go through the below steps.
Here I have two filter one is Segment and another is Customer Name as per your Query Lets if you want to select any State from the State Filter then on The Hospital filter the filter Automatically change on the basilic of State what we put on the State filter.
I am doing the Same when I select any Segment then the respective customer you can see on the Customer Name filter.
Step -1
Here we simply go to the Customer Name filter & click on the format control button and click on the show relevant value only.
Step-2
Once you select show relevant value only then a dialog box come into the screen and asking for selecting the control .
So here you need to simply select the Segment & click on the Update menu.
Then for testing I select one Segment Value so that you see the respective customer on that Segment value.
I select Segment as Startup so in the Customer Name filter it is automatically select the Startup related customer name .
Thanks