1 of 1 people found this helpful
Yes you should use a parameter, first click on the dropdown and select create parameter:
Set the type as float and display format as currency custom with 2 decimal places with the currency symbol, then click ok.
Next thing to do is LINK this parameter to the dataset. To do this, create a calculated field. Click on the drop down from the very first step and create the below calculated field:
So in my example, I am multiplying sum of sales by the multiplier amount in the parameter.
Next thing is to USE this calculated field, so I'm going to put it on my rows:
When you change the value in the parameter it will update the chart.
I've attached a workbook so that you can take a look.