Hi Guys, I am preparing a report like this Order Category ItemsOrderedbyCustomer1 ItemsOrderedbyCustomer2 ItemsOrderedbyCustomer3 TotalOrderedItems Toys 12 60 5 77 Clothes 10 5 45 60 Shoes 20 4 25 49 Watches 15 10 5 30 I am getting the data in the same format from SP so I don't have any problem up to this part but Now I want to add another row in the Report at the Bottom for the totals Like this Order Category ItemsOrderedbyCustomer1 ItemsOrderedbyCustomer2 ItemsOrderedbyCustomer3 TotalOrderedItems Toys 12 60 5 77 Clothes 10 5 45 60 Shoes 20 4 25 49 Watches 15 10 5 30 Total 57 79 80 216 Is there a way to do it, it might be easy to you guys but I am pretty new to SSRS. Thanks in Advance

Hi Entry Level, Try this, Create footer as "Total" and than you can use expression as:- In 2nd TextBox, =SUM(Fields!ItemsOrderedbyCustomer1.Value) In 3rd TextBox, =SUM(Fields!ItemsOrderedbyCustomer2.Value) In 4th TextBox, =SUM(Fields!ItemsOrderedbyCustomer3.Value) In 5th TextBox, =SUM(Fields!TotalOrderedItems.Value) Please let us know your feedback. Thanks KumarKG

Thanks Kumar thanks for the reply and I got the answer