Sum Month with Month-1

[ptl14624]

Hi!

I want to sum the sum of the current month, to the sum of the last month with values.

For example, in February I want to have all the Páginas Produzidas of February and January (image below).

Any Ideas?

Thanks

[sunny_talwar]

What expression are you using in your chart? Assuming it is Sum(Measure), change it to this

RangeSum(Before(Sum(Measure), 0, ColumnNo()))

[OmarBenSalem]

How to use aggr sunny in such a case; because, if the sorting order is altered, the results would be wrong.

[sunny_talwar]

Depending on the dimensions (assuming there is only one dimension in this chart which is MonthYear)... you can do this

Aggr(RangeSum(Above(Sum(Measure), 0, RowNo())), (MonthYear, (NUMERIC)))

[OmarBenSalem]

I we have one line and 2 columns

it would be ?

Aggr(

Rangesum(above( 

sum(Measure) 

,0,rowno()))

,Col2,Col1,Line1)

??

I tried as follow, it returns 0