1 Reply Latest reply on Dec 17, 2016 10:28 PM by Shinichiro Murakami

    what if scenario based on reference investment v revenue table

    Ian Barton

      Hi All,

       

      Ive seen the following article on how to create parameters and allow user input to crete what if analyses.
      http://www.evolytics.com/blog/tableau-201-how-to-make-a-what-if-analysis-using-parameters/

      The output appears linear. I.e If investment is increased by 5%, sales increase 5%.


      I was hoping the expand on this with the following. How would I create the functionality to refer to an investment v revenue table. i.e a non linear curve so for example if investment (Y) is increased by 5%, the revenue increases by X%. The x and y would be defined in a reference table. The attached image is  graphical representation of this table.

       

      Thanks