Full Accumulation in Expression

[#1]

Hi, there.

I'm a newbie in QV and cannot solve my problem with full accomodation in expression.

Expression looks like this, crucial dimension is Seria:

sum(aggr(RangeSum(above(sum({$<[Kód]={D01TSČ}>}Čiastka),0,RowNo(TOTAL))),Obdobie,Séria,Fáza,Kód,Rok))

I need cumulatives like this BUT IN EXPRESSION !

Thanks in advance.

Duski

[MK_QSL]

sum(aggr(RangeSum(above(TOTAL sum({$<[Kód]={D01TSČ}>}Čiastka),0,RowNo(TOTAL))),Obdobie,Séria,Fáza,Kód,Rok))

[#3]

Edited.

Thank You, Manish, for your answer, but your suggestion returns incorrect results 😞

Source data look like this:

Series Plan

Series Uctovnictvo:

Another suggestion ?

Thanks in advance

Duski

[MK_QSL]

Provide sample data pls...

[#5]

EXCEL with source data attached.

Thank you in advance, Manish.

Duski

[MK_QSL]

Try

RangeSum(above(TOTAL sum({$<[Kód]={D01TSČ}>}Čiastka),0,RowNo(TOTAL)))

or

sum(aggr(RangeSum(TOTAL above(sum({$<[Kód]={D01TSČ}>}Čiastka),0,RowNo(TOTAL))),Obdobie,Séria,Fáza,Kód,Rok))

[#7]

Thank you, Manish, but ...

- first formula returns same data as above (not correct)

- second formula returns no data 😞

Did you simulate my chart with my source data with correct result ?

Thanks in advance.

Duski

[MK_QSL]

What are the two expressions you are using in Bar Chart?

Bar Char

Dimension

Obdobie

Expression

RangeSum(above(TOTAL sum({$<[Kód]={D01TSČ}>}Čiastka),0,RowNo(TOTAL)))

is working with me

[#9]

And the result looks like this ?

[MK_QSL]

I haven't used aggr...