September 28, 2011 at 7:58 am
I need to create a report which needs to display grand average from the group average. In SSRS 2005, I created a table:
Depot AvgTemp
1 10
2 20
3 30
Area1 20
4 25
5 35
6 null
Area2 42.5
District 1 31.25
I have a group on "Area" and "District". I was able to get the average of "Depot" in each "Area". But for the average of "District", I need to get average from "Area" average, i.e, (20+42.5)/2 = 31.25. However, right now I am getting average of depots in a district, i.e, (10+20+30+25+45)/5 = 24.
Any help is appriciated!!
October 21, 2011 at 2:55 am
Hi,
I would create a separate dataset and table for this which returned the averages for each Area Group. From this dataset you could work out the District Average.
When the values shown in this new table are correct you can hide the table and use the reportitems function in the report to place the value in a cell in you main table.
The reportitems function allows you to copy the value returned in a cell to another cell.
The formula is =reportitems!FIELDNAME.value
I am assuming that you will only one district average?
If you have multiple district averages you will need to use a different approach.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply