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.

[adamdavi3s]

Try replacing Above with Before instead

[ch_riadh]

No, Same Issue.

[adamdavi3s]

Hmmm weird it should work, can you share your expression as the one above looks incomplete (missing set analysis brackets)

Missing Manual - Before() and After()

[ch_riadh]

RangeSum(Above(TOTAL Sum(Pipeline) , 0, RowNo(TOTAL))) this is work fine when the monthyear dimension is a row dimension,

but i move it up to Column dimension goes wrong.

I tried 'before' , 'after' . not working

If you can do it for me i ll be thankful.

you can use the data in the excel u shared.

Thanks for help.

[tresesco]

Before() should work unless you are using multiple expressions in the chart and wishing to add up all of them. Could you post a sample qvw that demonstrates the issue?

[ch_riadh]

I share with you the excel, can you try to do it ?

Thanks

[ch_riadh]

hello, you did it ?