Totals dont show with Rangesum

renjithpl — Fri, 06 Dec 2013 07:08:30 GMT

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

Re: Totals dont show with Rangesum

kaushiknsolanki — Fri, 06 Dec 2013 07:35:11 GMT

Kindly share your application.

Regards,

Kaushik Solanki