I need to create a report which needs to display grand average from the group average. In SSRS 2005, I created a table: Depot Avg Temp 1 10 2 20 3 30 Area 1 20 4 25 5 35 6 null Area 2 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!!

The easiest way to do this is behind the scenes in your query or proc. Hope that helps! RyanRyan