Calculate total of specific rows

Hi all,

Been a while since my last post but I have a BI Report Studio query…
I am trying to calculate the total of two specific groups within a report - how do I do this without having the total aggregation run throughout the rest of the report? Is there a query that I can run to have only the total of these two groups displayed in the report?
Does anyone have an example using the gosalesdw sample data of how to do this?

Any help would be greatly appreciated.

Thanks in advance,
tdsrogers

See if these help:
http://www-01.ibm.com/support/docview.wss?uid=swg21343181

http://www-01.ibm.com/support/docview.wss?uid=swg21370620