My salesforce query returns currency fields in their original currency. So a table would look like this:
Name | Amount | CurrencyIsoCode
Opp A | 1200 | USD
Opp B | 2342 | GBP
Which makes aggregates non-sensical unless you convert.
I'd like to be able to unify the currency to GBP.