Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
My friend, I said two different expressions... not in one...
sum(aggr(RangeSum(above(TOTAL sum({$<[Kód]={D01TSČ}>}Čiastka),0,RowNo(TOTAL))),Obdobie,Séria,Fáza,Kód,Rok))
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
Provide sample data pls...
EXCEL with source data attached.
Thank you in advance, Manish.
Duski
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))
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
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
And the result looks like this ?
I haven't used aggr...