Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gfmeekins
Starting Member
1 Post |
 Posted - 2009-08-03 : 12:14:07
|
| Good day,I am working on an issue with Averages in the sql 2005 SSRS. I understand that to gain an average, you must use a few nested inscope calls in the expression. However, I'm not able to get it to work. There are 4 row categories and the grouping is on day of month. The subtotals work just fine but I just can't get the monthly average of the counts by day to work. The example below does not translate well in this message. Day of month Average 1 2 3 4 5 Adult Male Category1 Cateogory2 3 4 1 1 1 2 Category2(1) 5 5 1 2 3 2.8etcEverything is fine with the report except the average. I just can't get that onto the report. Please advise - I may need more elementary instruction than some. |
|
|
|
|
|
SSRS Matrix Report Averages