Forum Discussion
Helper IIIChanging two columns on a table into various alternatives
Resolver IIYes, you can use field parameters to switch between specific measures, in this case one for each currency.
Alternatively you can use dynamic formatting.
Helper IIIThis partly works - however - I have multiple columns for the same currency (members get a discount, etc), and I'd really like a drop down where I could select GBP and get the 2 columns shown without having to make individual selections, but that seems impossible.
- dlopesc04
That is definitely possible though
- twofingertyper
I kept going around in circles on Friday, as the values are stored as strings (because I want to put AUD $, USD $ in front of them instead of just a number) it didn't work as I expected.
It may be that I could unpivot the columns (so that I get multiple rows for each product with each currency line, as opposed to one line with all currencies) and approach it from that way, but I ran out of time on Friday for what was a 'nice to have' rather than 'must have' feature.