Totals dont show with Rangesum

[renjithpl]

Hi all,

I have this comparitive analysis chart, when i pick Month as dimension my totals in the straight table dont show up.

This is my formula.

rangesum(above(Sum({<[Financial Year]=, Day=, Month=, Date={'>=$(=monthstart(min(Date))) <=$(=max(Date))'} >} [Daily Margin@AUD])/1000,0,1))

This formula returns the monthwise cumulative scores.

For eg.

Month     Value     CumValue

Jan          25          25

Feb          5           30

Any suggestion to get the totals?

Cheers

Ren

[kaushiknsolanki]

Hi

     Kindly share your application.

Regards,

Kaushik Solanki