Hi,
i have a line chart with a kpi which calculates a percentage (accumulated):
Sum(x) / Sum(total y)
The chart has 2 dimensions:
- on the x-axis there is a month dimension
- the second dimension is 'Category' and is supposed to show a separated line in the chart accordingly
My problem is the following:
I want the 'total' in my formula only to apply to the first dimension (months).
So the sum of y is supposed to be over all the months.
However i want it not to be over all Categories.
Is there a way how to achieve this?
