Dear ALL; i have a report which is displaying this customer amount1 amount2 amount3 A 100 200 Amount1-Amount2 A 100 300 Amount1-Amount2 B 300 100 Amount1-Amount2 what i want to group by the customer an the display should be customer amount1 amount2 amount3 A 100 500 Amount1-Amount2(100-500) B 300 100 Amount1-Amount2(300-100) Total---------------------------------------------------------------------------------- 400 600 how can i achieve this

Hi There Please add a tablix to your report and please add amount1 and amount2 in the details group. if you one customer could have multiple records then please right click on your detail row and add group parent group and put the customer there Now create the expression for your amount3 like this =Fields!amount1.value-Fields!amount2.value =Fields!amount1.value-Fields!amount2.value Now please right click on your details row and add total after and put expression for summary like For amount1 =sum(Fields!amount1.value) sum(Fields!amount1.value) And for amount2 =sum(Fields!amount2.value) =sum(Fields!amount2.value) And for amount3 sum(Fields!amount1.value-Fields!amount2.value) I hope this will help Many Thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful

Hi There Please add a tablix to your report and please add amount1 and amount2 in the details group. if you one customer could have multiple records then please right click on your detail row and add group parent group and put the customer there Now create the expression for your amount3 like this =Fields!amount1.value-Fields!amount2.value =Fields!amount1.value-Fields!amount2.value Now please right click on your details row and add total after and put expression for summary like For amount1 =sum(Fields!amount1.value) sum(Fields!amount1.value) And for amount2 =sum(Fields!amount2.value) =sum(Fields!amount2.value) And for amount3 sum(Fields!amount1.value-Fields!amount2.value) I hope this will help Many Thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful