Comulative Values

[subbareddykm]

HI All , I

I m calculating values over Id and month , it is giving me correct result but i make any selection in month the same values are not coming same .

For example in my attached file, first dont select any month  and see the value for every ID wise  (For Jan )and select Jan  month and Check the value ,

Not showing the same values.

Can any one tell me how to get this ?

[Gysbert_Wassenaar]

Try this one:  sum(aggr(rangesum(above(total sum({<Month=>}Value),0,RowNo(total))),Month,ID))

[subbareddykm]

Hi ,

Thank you so much for ur responce,

In this expression , its giving me correct as per the data, But If the ID are not same for every month, then in that case its not giving me correct values.

[sunny_talwar · Accepted solution]

Try this:

RangeSum(Above(TOTAL Sum({<Month>}Value), 0, RowNo(TOTAL))) * Avg(1)

[subbareddykm]

HI Sunny,

Its working fine.

Can u explain me , why we used here    * avg (1)

[sunny_talwar]

Check out my explanation about Avg(1) here:

Re: Chart Funcationality: How can I ignore evaluation of second dimension (for an expression)?