I am using a matrix . The Row Group is a Parent-Child Dimension. I have pivoted the lowest level in the Parent Child Dimension for the column. Initially for the data cell I was using, sum(ParentChildField.value,"matrix1_Parent_ID", Recursive). That skewed the results,giving some Totals * 2. Now I am using the Expression below. How would you get this to work with using the Divide by 2 "sum(Fields!Amount.Value)/2"? I understand why I need to divide by 2. I am not usre why the recursive does not work, and how it works as well. Below the expression is a dump of the report from excel using the divide by 2 expression. Any clarification will help. =Iif(InScope( "matrix1_Description"), Iif(InScope("matrix1_Parent_ID"), Sum(Fields!Amount.Value), Sum(Fields!Amount.Value)/2), Iif(InScope( "matrix1_Parent_ID"), sum(Fields!Amount.Value), sum(Fields!Amount.Value)/2)) Pizza Subs UNKNOWN Total Expressy 5917 9982 4305 20204 ACCESS 5834 9556 15390 ASAM 11 10 21 CAM 6 69 75 CORE 3 29 32 DCAM 16 230 246 FWAM 6 14 20 MANAGED LAB 0 0 0 MFAM 8 27 35 MPAM 29 19 48 OTHER DEVICES 4305 4305 RAM 4 4 8 SAN 0 24 24 TZ 681 606 403 1690 IWIN-TZ_AMERICAS 1 0 1 IWIN-TZ_APAC 4 8 12 IWIN-TZ_EMEA 12 11 23 IWIN-TZ_INDIA 6 4 10 OTHER DEVICES 403 403 TZ 658 583 1241 WIN 6717 10745 1459 18921 ACCESS 5893 9591 15484 CORE 42 40 82 DIST 428 254 682 IWIN-AMERICAS 17 18 35 IWIN-APAC 69 109 178 IWIN-EMEA 38 75 113 IWIN-INDIA 46 67 113 OTHER DEVICES 1459 1459 SAS 184 591 775 Total 13315 21333 6167 40815DBA Developer

Hi The simple solution for this problem is that just right click on Row Group (which will be 'Pizza' in your case) and then 'Add Total' after that just go to After. I think this will solve your problem. If you are not able to do this then let me know.Cheers!! Sumit