1 of 1 people found this helpful
You can create another parameter (Parameter_measure) with value "Sales" and "Unit"
and then create another calculation field like below
when "Sales" then [Parameter - Currrent Sales]
when "Unit" then [Parameter - Current Unit]
Thanks ZZ it works just fine now.
Zhouyi Zhang a follow up question to my previous.
Now I have parameters for time (YTD/QTD/MTD) and I have one for Sales/Units. They work very well togather with your help.
Now I would like to be able to choose what currency. I am not sure how to make Another parameter to add them all togather. Local vs USD works fine on its own but how can I make all three work toghater?