Hello, We have a column for customer names. And customer named John Smith has made 8 purchases, so we have 8 rows for John Smith with different amounts in amount paid column for John Smith. How can I sum-up all amounts paid by John, next customer and so on. And show total for each client in his/her row? Thanks
1. Select the detail rows on the tablix. 2. Right click and select add group 3. Click Parent Group 4. select the group by column as customer name 5. Tick add the group header and click ok 6. Delete additional column just got created at the left corner of the group 7. Enter customer name and sum(amount) into the columns of the new group.