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
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
eur 50 at the end of the column.
Please suggest how i should go about this..
Thanks in advance.