Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Can anyone suggest on this.See table below
I have a calculated column Cumulative where im using rangesum
=RangeSum(before(Sum(Value),0,ColumnNo()))., with this expression it calculates the value for nov dec and jan whereas i have data only till oct, so nov dec and jan should show blank.
For reference pls see attach application.
Item | Month | Value | Cummulative |
A | Mar - 2013 | 10 | 10 |
A | Apr - 2013 | 1 | 11 |
A | May - 2013 | 14 | 25 |
A | Jun - 2013 | 2 | 27 |
A | Jul - 2013 | 27 | |
A | Aug - 2013 | 27 | |
A | Sep - 2013 | 4 | 31 |
A | Oct - 2013 | 98 | 129 |
A | Nov - 2013 | ||
A | Dec - 2013 | ||
A | Jan - 2014 |
Thanks
Regards,
Tom
Hi,
Have a look at the application.
Regards,
Kaushik Solanki
Hi Kaushik,
Thanks for your help.
But didn't achieved what I looking for.Here in your attach application the Month year showing only till Oct'13 ,in my case it should also show Nov,Dec and Jan as Blank.
Regards,
Tom