I think you could just use a sum with appropriate total qualifier:
I assume you have three dimensions in your chart like Dim1, Dim2, Dim3 (where Dim1 has values like F&C, Dim2 like Personalaufwand... and Dim3 are the Months).
Then you could use
where VALUEFIELD is the field containing the numbers your blue and green values are based on.
Hope this helps,
Thank you for your support. I have five dimensions in my diagram. I tried your example like:
In the diagram there are five dimensions. I tried your example on the following:
sum(total< PD_OBERBEREICH, PD_KOSTENGRUPPE, PD_CAROTKONTONAME> PD_WERT )
But the values are not always correct. See Screenshot
Or see my qvw file
why do you divide your sum 1-12 months by 10?
I noticed that you have several records per combination of your dimensions, sometimes 10, sometimes 5, sometimes more than 10.
Maybe try this:
sum(total< PD_OBERBEREICH, PD_KOSTENGRUPPE, PD_CAROTKONTONAME> PD_WERT ) / count(PD_WERT)
to get an average value.