Hello, I have two simple questions. The first questions is: How to sum columns in matrix, I have 5 columns and I want column sum 1 and 2. The second question is: How to sum rows. I create query =avg(iif(filds!urgency.value=1 and filds!_time<=14,1,iif(filds!urgency.value=2 and filds!_time<=130,1,0)), everything is ok, but I must sum average of average .

Question 1) Create a Calculated Field e.g. "=Field1 + Field2" Report Data --> Right Click DataSet --> Add Calculated Field Question 2) Add a Total Right click field in question --> Add Total Bonediggler

This tutorial will help you understand how column and row totals work. http://msdn.microsoft.com/en-us/library/bb630415(v=sql.100).aspx ThanksFrancis, MCTS: BI 2008, MCITP: BI 2008 Stay Thirsty My Friends

I'm sorry, The first questions: Is OK, I have problem with value from sql, because the value was varchar not int. It's my mistake. thanks for answer Question 2-> Is not the simple, when I use "add total", gets the results sum of avg, but I want avg of avg. correctly results is 97,50% MostInterestingMan I'll check this link. thansk