I want to connect two (both ID filters) dashboard filters. When I fill 1st filter second should automatically select corresponding ID.
When I select 2345 in Sub_campaign_id filter Campaign ID should automatically change to 1
Example:
Campaign ID 1 - Sub_campaign_id 2345
Campaign ID 1 - Sub_campaign_id 3345
Campaign ID 2 - Sub_campaign_id 6677
Campaign ID 2 - Sub_campaign_id 9032
Campaign ID 2 - Sub_campaign_id 9021
Campaign ID 3 - Sub_campaign_id 2134
Campaign ID 3 - Sub_campaign_id 2555
Thank you