Hello, I have an problem with my group total. My child group total has logic inlcudes IF Customer Count <=5 THEN Customer Count*80$(Basic Payment) + Customer Count*15$(Additional Payment) = 475$ ELSE Customer Count*80$(Basic Payment) =480$ Parent group total Customer Count Pay Child group Payment 5 475$ Payment 6 480$ Total 11 880$ But When I calculate parent group total Customer Count is 11 that is why it shows 880$ instead of 955$ = 475+480. How do I need to calculate it correct amount 955$. I tried to use cutom function to calculate grand total it show correct result but whenever I navigate the page total amount total value keeps changing because of Public Shared Variable I used. (It renders correct result on pdf, xls etc but not on report manager) FYI: I am using SSRS 2008 R2 Thanks in advance

Hi, Remove the grouping for the third row and write the expression SUM(rowfield) the you will get the correct count. Thanks, FunBI

Hi, Thanks a lot for your response. But I can't just SUM(rowfield) because the Total pay is textbox expression with really complicated logic including count and sum etc. So just can't simply aggregate of aggregate. Also I can't use Sum(ReportItems!TextBox.Value) and variable value can not be used in aggregate function error. I'll try to explain more specific. Total pay logic includes following expression. IIF(Variables!Count <=5, Variables!Count .Value * 15 + SUM(Fields!CustomerCount.Value * 80, "ChildGroup") ,SUM(Fields!CustomerCount.Value * 80)) So I need to get sum of Total pay on Parent Group. But that gives me incorrect result. IIF(Variables!Count <=5, Variables!Count .Value * 15 + SUM(Fields!CustomerCount.Value * 80, "ParentGroup") ,SUM(Fields!ParentGroup.Value * 80))