How to add the value in a coloumn to the above value in the coloumn

[ak00428233]

Hi,

i have a problem in displaying values.Could anyone suggest the expression for it.

I have values like

MONTH YEAR JAN 2015     FEB 2015       MAR 2015      APR 2015

Toyota               1234            4567            6789                9012

BMW                 2345            6789            9012                3456

aUDI                  3456            7890            1234                5678

The result i want to get is like

result                   3456           (3456+7890)       (3456+7890+1234)   (3456+7890+1234+5678).

Could anyone suggest the expression to get the result in the above way.

pls help me if you know this

regards

K.Anuraj

[PrashantSangle]

Hi,

try Full Accumulation option from straight table->Expression tab.

Regards

[jagan · Accepted solution]

Hi,

Check try like this

=Rangesum(Sum(Sales), Above(Sum(Sales), 0, RowNo())

OR

=Rangesum(Sum(Sales), Before(Sum(Sales), 0, ColumnNo())

Hope this helps you.

Regards,

Jagan.

[Digvijay_Singh]

tweaked a bit the exp suggested by jagan.

=Rangesum(Before(Sum(Data), 0, ColumnNo()))

[ak00428233]

Thank you Jagan I am getting the values by writing that expression

[ak00428233]

Thank you Digvijay Singh