column to column summation

[#1]

Hi Friends,

I have set of values calculated as shown below...

Dimension	A	B	C
Bat	5	3	7
Ball	10	7	2
Stumps	3	2	4
Gloves	2	5	3

From the above, i need to get the below result by summation of each column to column.. Kindly help

Dimension	A	A+B	A+B+C
Bat	5	5 + 3 = 8	5 + 3  + 7= 15
Ball	10	10 + 7 = 17	10 + 7 + 2 = 19
Stumps	3	3 + 2 = 5	3 + 2 + 4 = 9
Gloves	2	2 + 5 = 7	2 + 5 + 3 = 10

Thanks in advance...

Ram

[sivarajs]

Check the attached file

[#3]

thanks for reply sivaraj but actually the value A,B and C is also dynamic ..

i have to calculate the summation of BAT,BOWL induvidually for (say..Customer) A,B and C

and also have to show the summation of previouly calculated value with current value.

Tat;s the complexity involved in this case..

How can we rectify this.plz share if u hav idea..

[#4]

Once again, thanks for yr reply .

But those value A, B,C is dynamic value.It might have D for some cases and even E,F for some other..

That's depend on selection.

so, i cant use columns as suggested.

Kindly advice , how can we handle the above case..

[#5]

sorry, its not works for my case.... Checked yr last sample file.

In that label A , B and C  has no links for selection.

Lets group it as Customer where values of customer be A,B and C.

Have to calculate the summation of items based on the customer selected.

For example, if user choosen A and B alone, hav to show the details on A and B alone.I cant hardcore sum(A+B+C) in expression. its an dynamic value.

thanks for yr prompt reply..

[#6 · Accepted solution]

Hi friend,

I got the desired answer by using the below function :

rangesum(sum(value),Before(EXpressionLabel))

Thanks for replies.....