i have a filter action for regions from worksheet 1 to worksheet 2. If i filter a specific region, e.g. AMERICA, the filter action gives me the correct region on worksheet 2. But when i filter "All" nothing is selected on worksheet 2. How can i do a action filtering to use all regions on worksheet 2 once "All" on worksheet 1 is selected?
since my workbook is connected to an OLAP Cube I can´t extract the data and provide workbook here. But as you can see attached, nothing is selected. I want to achieve that if "All" is selected on worksheet 1, it should select all Regions on worksheet 2.