-
1. Re: changing the measure value using parameter having 90+values
Zhouyi Zhang
Jan 9, 2018 10:39 PM
Hi, Anjali
How is your data looks like? Does your currency value in column level or in Row level?
If it is column level, you may try pivot the data, or if it is row level, then drag currency column to filter
It will be helpful if you could provide sample data or workbook.
ZZ
-
2. Re: changing the measure value using parameter having 90+values
Hi Zhouyi,
The currency is not present in data. I need to create a parameter for it.
Thanks,
Anjali
-
3. Re: changing the measure value using parameter having 90+values
Zhouyi Zhang
Jan 10, 2018 4:58 AM
Please share a sample data or sample workbook, otherwise, it is not helpful to look into your question
ZZ
-
4. Re: changing the measure value using parameter having 90+values
Hi Zhouyi,
Please see attached the sample file. I have to add more 90 values for currency type in the parameter. In that case apart from using if else block, is there any way to calculate the sales value which will change with changing parameter selection.
Thanks!
-
5. Re: changing the measure value using parameter having 90+values
Zhouyi Zhang
Jan 11, 2018 4:05 AM
Hi, Anjali
Please find my solution attached and below is the screenshot of steps
Hope this could help
ZZ
