Line chart mit two dimensions and 'total'

[schmidtj]

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?

[schmidtj · Accepted solution]

Ok i found the solution:
Sum(total <...> y)