Accumulated values, additional dimension

[markusblaut]

Hello together,

If(FiscalYear = '2015',

(RangeSum(above(Sum({<FiscalYear = {'2015'} >} OQ),0,rowNo())) ),

If(FiscalYear = '2016',

(RangeSum(above(Sum({<FiscalYear = {'2016'} >} OQ),0,rowNo())) ),

If(FiscalYear = '2017',

(RangeSum(above(Sum({<FiscalYear = {'2017'} >} OQ),0,rowNo())) ),

If(FiscalYear = '2018',

(RangeSum(above(Sum({<FiscalYear = {'2018'} >} OQ),0,rowNo())) ),))))

)

the formular works to get the accumulated values in the first diagram (combi-diagram)

the formular does not work in the second diagram (a normal diagram with an additional dimension (typ-Qty)

Does anyone has an idea to make the accumulated formular work with an additional Dimension?

Many thanks for any help!

Best,

Markus