SSRS Show all subtotals for each currency at bottom of report

Viewed 67

I'd like to show the subtotals for each group at the bottom of my report, rather than inside each group. How can I do this?

enter image description here

enter image description here

2 Answers

Create another dataset that subtotals by currency and add a table at the end the displays the results.

You could add a second grouping to the table and group by your group. Right-click on the group --> Add Group --> Adjacent Below.

enter image description here

Then you'll have an extra grouping in the same table.

enter image description here

Or create a separate table using the same dataset but grouping by each group.

Related