Question Locked
Summing an average(SQL 2005 Reporting Services)
0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have a matrix that groups and averages some values that can be represented thus:
FTE
1.2
0.8
2.0
I would like to total the column in this manner:
FTE
1.2
0.8
2.0
4.0 - Total
When I use the built in Total I get an average instead
FTE
1.2
0.8
2.0
1.33 - Total
Any ideas?