The solution included four elements:
- A calculated dimension which was composed of country field + 'European Union'
- A variable to keep list of EU countries
- A variable to keep the list of selected countries in the country field
- An expression which could calculate total sales for country field and 'European Union' separately.
https://sites.google.com/site/quickdevtips/home/CalcDim1.qvw
Thanks Aydin, this is a great example!
ReplyDelete