Customize sub totals

[royalen]

Hi Guys

Need some thoughts around Sub totals and totals on a list. For example i have a list which gives transaction amounts for a country in different currencies. So for the complete dataset the report should give totals for all the currencies. To make it more clear i have attahced an excel dataset.

I did insert a List in footer getting just the currency and totals and also did tried custom totals but when cognos sql/mdx is generated it shows multiple sql's being created. Any better way of doing it.

Thanks