I am currently creating a dashboard that we will be used for multiple countries. A problem is that people want to view the sales numbers in different markets in their own currency. What I would like to create is a filter that changes the values of the sales figures into the currency they choose. So if they pick USD, they will see the sales in USD, if they pick EUR they will see the sales in Euro etc. I want to be able to apply other kind of filters to the graphs as well.
I wonder if there is a not too complicated way to accomplish this? I have tried using SQL-questions and variables but I get stuck when it comes to being able to apply other types of filters to the question.
Thank you in advance.