Can you attach the workbook?
I am trying this in my organization , so I am not allowed to upload the file due to firewall.
The scenario is exactly same as I explained, it would be really great if I get help on this.
This is the critical requirement client is looking for.
For a pictorial view , this how the final look is :
So the Action filters are set as :
Click on Country - will affect City, Customer name , order ID, Order date
Click on City - will affect Customer name , order ID, Order date
Click on Customer name - will affect order ID, Order date
Click on Order ID - will affect Order date
Whenever I click on any country , then by default corresponding 1st city of clicked country ,
1st Customer name of first city,
1st order id of first customer name ,
1st order date of first order id should be selected