How to filter across different datasets

[Bruton3]

I have a few tables as order amount table, order ID table, order detail…, the tables as follows. Now I have filters based on calculated fields, for example, a filter to filter out customerID with OrderAmount < average order amount. Now my goal is when I filter out the customerIDs from the order amount table, order ID table, and order detail table would be controlled by the filter as well, meaning order ID table would only show customerIDs from the first filtered table and their OrderIDs, and the order detail table would only show OrderIDs from the 2nd table. Now joining tables is not a good option for me, as one customer can have many orders and one order has many items. I have read through a few answers here, still unable to implement right filters. Any help would be appreciated. Thank you.

order amount table

order ID table

order detail

[neelay]

@Bruton3 filter is tied with visual and dynamic parameter is tied with dataset.
to do what you are trying, I recommend joining these tables at the dataset level and then using dynamic parameters for customer_id, order_id, etc.

[Bruton3]

Hi @nshah-quicksight, thank you for the fast response. I was trying to avoid joining tables, but I guess that would be the only route. Maybe quicksight development team can look into this as a future feature. I don’t think I am the only one who would have this issue. I remember other BI tools such as Tableau can have a way to do this. Thanks again.

[Kellie_Burton]

Hi @Bruton3!
I will mark this as a feature request and share with QuickSight product management.