I hope i understood your requirements. You can do two or more sheets with separate filters that works for each sheet and bring them to the same dashboard. This way, you can switch each country in each sheet and compare it to another country in another sheet.

For my solutions, it doesn't really matter if it is live or extract as you will be creating the same view in 2 sheets with 2 filters that applies to each sheet and bring them to a dashboard. Does it make a sense?

I just looked at your file, and I couldn't figure out how you are differentiating GA and PH worksheets. Honestly, I have very hard time to understand your requirements and what you are trying to achieve. Can you be much more specific?

Thanks for specs, I see what you are trying to do now. I have never tried but you should be able to achieve that if you can union those Google Analytics accounts then you will have all countries in union data that will have a country field that you will use to switch countries. Please try and let me know how things go.

Norbert Maijoor

Would you be able to look at this for me? I am sure it is possible but can't think of another way to achieve what she is looking for. Thanks for your time.

Sherzod

I was wondering if you ever tried to blend them instead of join? Once blended based on common field, then you can bring from those different accounts to one dashboard.