I'm working with Sub-cat dimension and Sale per Month measure.
I want to have a requirement to put in sale number for specific sub-cat. For this, I created a parameter with Int and gave my desired range.
I want the calc to say
if sub-cat is selected then Range parameter
else avg sale per month
This gives the user to entire their own sale number within the declared parameter range and see how it will impact the over all company.
I'm unable to achieve this on my own. Please help. Attached is a sample workbook.
Your requirement is not clear.
Do you want to apply the value entered for the parameter to recalculate the existing average sales?
Can you give an example of what you are trying to do with the parameter value