HI, I have a Strange Requirement using SSRS 2005 Matrix. here in 1 row group I need Average of specified Group and right under it, I need Grand average of all the groups specified in the parametes.Trying to create a calculated field which can give me average of all the parameters involves. I'm using InScope and cannot proceed further, Any help is greatly appreciated. For Ex Average : 3.83 >>> Average for 1 Parameters Total Average 3.72. >>> Avg For all Parameters, Is there a way to create a calculated field using report Parameters. This is my code so far... =IIF(InScope( "grpCallRep") ,AVG(CDBL(Fields!Call_Scoring_Answer.Value)) ,IIF(InScope( "grpWorkGroup"),AVG(CDBL(Fields!Call_Scoring_Answer.Value)),0)) thanks, Vishal.

Hi Vishal, It's 100% doable, I have done some kinda of similar work before, please have a look at the below rdl files, this will give atleast some idea, how to achieve it! https://skydrive.live.com/#!/?cid=15e0e13bd0545504!cid=15E0E13BD0545504&id=15E0E13BD0545504%21137 "Total_AND_GrandTotal_Multiple_BenID.rdl" "Total_AND_GrandTotal_WithFilter_NEW.rdl" Note:- Change the DataSource1 as per your req. Please do let us know your feedback. Thanks KumarKG, MCTS

Kumar, thanks For Replying... but link dosent work.. can u plz resend it....

Hi Vishal, It does work even I have checked with others, I think you need to create an account on skydrive. Please do let me know if you have any more issues. Thanks KumarKG, MCTS

Hi Vishal, According to your description, you would like to create a calculated field which would calculate the average value of special group dynamically. Actually, Aggregate function cannot be used in calculated field expressions, calculate filed was only used to handle the columns’ data based on the same row but not the whole dataset. Instead, you could set the calculated expression for each textbox which you want to calculate the average values, or create a custom function to achieve the relevant function, and then call it directly. Additionally, I would suggest you submit a feedback at http://connect.microsoft.com/ .Connect site is a connection point between you and Microsoft, and ultimately the larger community. You feedback enables Microsoft to make software and services the best that they can be, and you can learn about and contribute to exciting projects. Appreciate your understanding. If you have anything unclear, please feel free to let me know. Thanks, Bill Lu thanks, Bill Lu