Is there any way to show the converted value of currency on just one row of data?
I have 5 customers. 4 of which made purchases in US Dollars. One made a purchase in Euros. However, the data is only passed back as the value of the purchase. No conversions are made or included in my raw data.
E (data is in Euros)
Is it possible to have ONLY Customer E's data converted to US Dollars? Or am I forced to simply hide/exclude Customer E and report on her separately?
Ideally the raw data would already be converted for me, but that isn't currently possible. Thanks for your help!