We currently have a table with multiple currencies, i.e. with columns like:
Revenue, Cost, Currency
5.50, 2.10, USD
3.30, 1.10, EUR
And ideally we want to prevent Looker users from summing over the Revenue without accounting for the currency (i.e. grouping by currency, country or city). What is the best way of dealing with this?
(We do not currently convert the currencies in the database)