0 Replies Latest reply on Sep 12, 2012 7:07 PM by julius golosinda

    What if scenario issue

    julius golosinda

      Say that sales is the result of the amount of GRP invested times a constant factor of 3.2. Tableau allows us to create a parameter control for the constant (3.2) so we can evaluate how the sales changes as the constant (3.2) is increased or decreased.

       

      Problem:  This method fails when the factor we want to adjust are the GRP's per period instead of the constant.

       

      Constant:

      3.2

      Sales:

      GRP x Constant

      Period

      GRP

      Sales

      1

      200

      640

      2

      300

      960

      3

      400

      1280

      4

      600

      1920

      5

      800

      2560

      6

      90

      288

       

       

      Is there a work around?