Hello all,
I have a table with revenue (in EURO) and sales. I also have the exchange rates between EUR and other currencies, and i want to create a filter that lets me change between the different currencies based on the exchange rate in 2018 and the variance for 2019 for Revenue. the Revenue and Sales are measures when i add them to Tableau.
Revenue EURLocationYearSales100Indiana201820150Indiana201830200Indiana201840250Indiana201950300Indiana201960350Indiana201970400Indiana201980Currency to EURO
Conversion RateCanada0.34USA0.46Indian 0.042Variance between 2018 and 2019Canada13.53%USA3.84%Indian2.11%9 answers
Hi Tre,
Create a parameter;
Canada
USA
Indian
Create a calculated field
CASE [Parameter]
when 'Canada' then 0.34
when 'USA' then 0.46
when 'Indian' then 0.042
Create 2nd calculated field
[Revenue EUR] * [first calculated field]
HTH when you change your parameter, the revenue will adjust accordingly.
Peter
