Hi I have a build a matrix report with three parameters and one of them is date, it gets data from a SSAS cube. The report displays data for the last five days by default when you click the report. The report has three columns date, organizations and Total, the report shows data for last five days by organization just fine, but the Total column shows wrong totals I cannot figure out what values it is showing. Any ideas how can I make the report to display the correct totals? For example: Organizations Date E I BR IT SC ST TOTAL 9/22/2012 0 0 0 0 0 0 4 As you can see above the 6 organizations have 0% for all 6 organizations but the total shows as 4%. I tried assigning the Date parameter as row filter in tablix properties but even then I had no luck.

At first glance this appears that it could be a scoping problem, that is, your summing expression in the Total column is summing items outside of the scope of the "Date" Row Group. I'm assuming Date is one of your Row Groups? In the summing expression of the Total column, have you specified the scope to be only for the "Date" row group? Also, what filters do you have on the tablix or any of it's associated groups?