1 of 1 people found this helpful
One approach is to use a Country filter and a Region parameter.
Step 1: Create parameter [Select Region]
Step 2: Create calculated field [Region 2]
Step 3: Create calculated field [Filter]
[Select Region] = [Region]
Set Filter to 'True' in Sheet 1 and 'False' in Sheet 2.
Step 4: Add [Country] and [Select Region] to your dashboard as filters.
Hope this helps.