You can remove and restore the country dimension easily to your chart. Make the dimension conditional on a variable, say vShowCountry. Create this variable in Variable Overview (via Settings) and set it equal to 1. In the Dimensions tab set the Enable condition for the Country dimension:
Add a button and set its text in the General tab:
Add an action to set the value of the vShowCountry variable:
That should do it. You should see something like:
Click the button and you should then see:
thank you, this is exactly what I need. I tried and it worked immediately with my data.
Now I have a bonus requirement:
I need to show the y-axis in relativ mode, i.e. 0-100%.
With the setting as in your example, the values add up to 100% when there is only one line, i.e. country is removed from dimension.
If there are separat lines for each country, each line only goes up to the percentage which reflects the ration of items sold in this country compared to the overall items sold.
Is there a way to scale each of the separat lines, so that every one of the goes up to 100%?
In fact, what I want to have is an empirical distribution function (Empirical distribution function - Wikipedia, the free encyclopedia), similar to what is shown in this picture (complete different data, just to show an example).
Thanks a lot,
Is this what your'e looking for? Use the expression given in the legend and in the expression tab select Full Accumulation. You can tidy it up a little by setting the Static Max to 1 in the Axes tab.
The TOTAL qualifier disregards any chart dimensions except any listed in the <>. In this case
Sum(TOTAL <Country> ItemsSold)
is a constant value for each month : the total number of Items sold in a country over all months. As the numerator accumulates to this figure for successive months the ratio approaches unity.