4 Replies Latest reply on Oct 11, 2016 8:01 AM by Shinichiro Murakami

    Parameters for blank columns

    William Hampton

      I have a situation where I have a sales metric for 2015 and want to use a parameter for my growth factor to predict 2016 sales.  I have a placeholder for 2016 in my raw data and want to figure out how I can create a calculation that will input my data into my dashboard.

       

      I have attached my workbook and a screenshot of my dataset layout.  My dataset layout looks like this:

      Year
      Sales
      Transactions
      2015$100050
      2016

       

      Ideally, I want worksheet to look like this using 10% as my sales growth from the parameter

       

      Metric201520152016
      Calculated Field$1,000$1,100

       

      However, when I do this using a case statement, 2016 stays blank (putting year as my column)

       

      Any help would be appreciated.