I have a currency filter, which works using fields in an inline table ,
I have created a variable using currency field in inline table , having exchange rates.
multiplied the variable in expressions of my metrics.
I used this currency feild from inline table as filter to affect the change in currency selections.
But filter is fixated on one selection. when i select other currency, it just wont select. ex - I have 5 currencies in filter but filter is fixated on EURO (millions) other currencies are greyed out and non- responsive. Please help.
In this example, "Sales" is the name of the field that contains the sales amount, and "vExchangeRate" is the name of the variable that contains the exchange rate. The expression multiplies the sales amount with the exchange rate to calculate the sales amount in the selected currency.
