1 Reply Latest reply on Jan 29, 2018 6:33 AM by Jyothisree Rayagiri

    Help with Parameter range

    shwetha sarma

      Hello,

       

      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

      end

       

      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.