SSRS Show all subtotals for each currency at bottom of report

141 Views Asked by At

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

There are 2 best solutions below

0
Chris Latta On

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

0
Hannover Fist On

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.