Last post Jun 06, 2011 11:26 PM by You-Hu Fu
Jun 01, 2011 11:12 AM|Jon11sin|LINK
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.
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
Jun 01, 2011 03:00 PM|Jon11sin|LINK
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".
Jun 02, 2011 12:47 AM|Ashutosh Pathak|LINK
i still didnt get you completely, can you elaborate a bit more, sorry my apology
Jun 02, 2011 10:39 AM|Jon11sin|LINK
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.
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.