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

    Help with Parameter range

    shwetha sarma



      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.