can I ask why you need add the country to context?
Hi Thanks for your response:
Here is the workbook and requirement -
I have 2 views in workbook
View 1 : Top 5 and others (remaining sales)
View 2: Sales % against all sales based on city selection - if I select NYC from global filter it should show NYC sales out of all the citys
( I have used LOD(fixed) since we are using context filter its not able to by pass LOD)
when I add NYC city in view 1: top 5 and others which is working fine but its impacting other view (view2)
goals is :
with global filters - Year,City and product category
I wanted to show top 5 and rest of others as in one view
and second view Sales % against all sales based on city selection - if I select NYC from global filter it should show NYC sales out of all the citys
can u please suggest if we select all countries from the filter I wanted to show Full Pie and number as 100 % instead of 0.0 and rest all working fine with your workbook
cause All is mandatory filter - when I select All which means I am comparing all countries sales vs all sales which should be 100%
Sorry about the late response to your question.
Please find my updates attached.
Below is the screenshot to answer your 1st question
And to your 2nd question of 100%, as your top N is based on product sub category, not country, so the % is based on top 5 sub category, no matter how many country selected or not.
Hope this makes sense.