Hi All, I want to find a SUBTOTAL for few fields alone My matrix will look like, Month Wise Group Year Wise Group 2010 Head count 10 15 25 Total Skill Set 10 50 60 2011 Head Count 25 30 50 Total Skill Set 10 25 85 Total Head Count 35 45 75 I need to find the sub total for headcount alone, if i give Subtotal, then the sub total for Headcount as well as total skill set is getting displayed. So plz help me

Hi SSunSon51, try these my sample rdl files, http://cid-15e0e13bd0545504.office.live.com/self.aspx/.Public/Total%5E_AND%5E_GrandTotal.rdl http://cid-15e0e13bd0545504.office.live.com/self.aspx/.Public/Total%5E_AND%5E_GrandTotal%5E_WithFilter%5E_NEW.rdl You can do something like that, just an fyi for using "RunningValue" in-built SSRS function. Also, you need to change the datasource to make this rdl files running successfully on your BIDS/Report Server. Please let us know your thoughts. Thanks KumarKG, MCTS

Hi SunSon, It is possible to get the sub total only for headcount, but I need to the dataset structure and the grouping structure of the matirx. For example, if head count and total skill set are stored in seperate column in the dataset, and there is only one row group of Year in the matrix, we can simply specify the expreesion =Sum(Fields!Headcount.Value) to the footer row to get the head count total. However, if both head count and total skill set are stored in the same column(for example "Amout"), in order to get the sum only for head count, we can use the expression like =Sum(IIf(Fields!Type="Head Count",Fields!Amount.Value,0)) Thanks, Tony ChainTony Chain [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.