Summation of different currencies in a column.

Hi Experts,

I have a report whose output has various quantity columns and currency columns.The currency column specifies whether the corresponding value in the quantity column is in gbp or eur or inr etc..

I want that when I select a quantity column and press the sum button it should give me the sum of all the different currencies there

eg..

currency | quantity

gbp | 20

inr | 50

eur | 50

inr | 40

inr | 100

gbp | 70

when i chose the quantity column and press sum it should give me the result as gbp 90

inr 190

eur 50 at the end of the column.

Please suggest how i should go about this..

Thanks in advance.

Regards,

Puja