Cumulative By MonthYear , Column Level

[ch_riadh]

Hi,

I tried to create a Cumulative sum By Month, with expression :

RangeSum(Above(TOTAL Sum({<Pipeline) , 0, RowNo(TOTAL)))

it works fine when the MonthYear Dimension Row Dimension like in the straight Table,

but when i move the MonthYear Dimension up, Column Dimension like in Pivot table or use same expression in chat it goes wrong, Because it works only with row.

Please check the excel attached so you can understand more.

Thanks for help.

[pathiqvd]

Hi Riad,

     Try this, May be you will get

=rangesum(Before(sum(pipeline),0,ColumnNo()))

Regards,