I am currently happy with the results. Short explanation about the contents you see in the screenshot:
It is a bar diagram about all people visiting a place througout given years with gender F/M. (you can ignore the third dimension)
Now what i would like to have for this diagram. I would like to add 2 buttons (they basically do the same):
If i press the "aggregate gender" button. The split columns of (F/M) should sum up and only show the total amount per year.
The second button would be similar - would be an "aggregate year" button. If i press this button, all the years would fall together, so that i would only have 2 columns - F/M - with the total amount of visits for all years.
ok this one is pretty similar to what i tried out before. Unforunately it does not work yet as you described.
But anyways! You pretty much gave me the solution to the much more important question i had before! So thank you - i guess i will find a solution for the second part with a bit of trial and error! So once again, thank you for your help!
Hi Daniel, wich part doesn't work? the variable values or the final chart?
For the variable value I forgot to add the intial '=':
For the second part, you can consider to remove the 3rd expression (wich I think is the blue-red stacked bars) to 2 expressions, using set analysis to filter each expression by the actual dimension values. This way you have two dimensions and 2 expressions, this allow you to set the 'Stacked' style and will return two columns, one for each gender, and stacked expressions.