## 5 replies

Last post Jun 06, 2011 11:26 PM by You-Hu Fu

• Jon11sin

Member

9 Points

194 Posts

### How to add up a row of column

In my report, I have a tablix.  I have 10 columns in the first row.  I want to be able to add up all the columns in the same row and display the total at the end of the row.  Any help is appreciated.

• Ashutosh Pat...

Contributor

3602 Points

1071 Posts

### Re: How to add up a row of column

Jun 01, 2011 01:27 PM|Ashutosh Pathak|LINK

you can use sum(Fields!column1.value)+sum(Fields!column2.value)+sum(Fields!n......) etc at the end of the Row Cell inside the Tablix

Ashutosh Pathak
Blog: http://catchcode.blogspot.com

• Jon11sin

Member

9 Points

194 Posts

### Re: How to add up a row of column

Sorry I had left out an element to the question.  Again I apologize.  Based on values within every other column within the row, then total at the

end of the row would change.  For instance:  "A" would consist of adding value to total,  "B" would consist of adding value to total and the value of "A", "C" would consist of replacing the total with the value of "C".

• Ashutosh Pat...

Contributor

3602 Points

1071 Posts

### Re: How to add up a row of column

Jun 02, 2011 12:47 AM|Ashutosh Pathak|LINK

i still didnt get you completely, can you elaborate a bit more, sorry my apology

Ashutosh Pathak
Blog: http://catchcode.blogspot.com

• Jon11sin

Member

9 Points

194 Posts

### Re: How to add up a row of column

Ok.  the row of columns in the tablix will have values as such.

1styr    2ndyr  3rdyr     4thyr     5thyr

65 original total    20 A     30 B    25C     20C       10A           30 total

The total of 30 is from the addition of the 20C and the 10A.  Based on the letter C it will replace the existing original total and since the letter A is displayed the next year afterwards.  It will be added to the value next to the letter C.   Since the 20C is in a later year than the 25C then the 20C is to be the new total.  Hope what I stated makes sense.   So this is what I'm trying to accomplish.

• You-Hu Fu

Contributor

6670 Points

794 Posts

### Re: How to add up a row of column

Jun 06, 2011 11:26 PM|You-Hu Fu|LINK

I am still a little confused about the letter A B C. I cannot understand you logic requirement.

Please mark the replies as answers if they help or unmark if not.
Feedback to us
Microsoft One Code Framework