1 Reply Latest reply on Jan 21, 2016 10:55 AM by Thomas McCullough

    Previous week's value, without displaying week

    Shantanu Mendhekar

      Hello,

       

      I am looking for an innovative solution to the following issue.

       

      From the screenshot below, the [Quantity] is the SQL Server table data, and [Quantity CF] is a Calculated Field that pulls in value from the previous cell. Since, Week 1 has value NULL it pulls in the [Stock] value of 50. Ideally, when I just want to display Week 3 and onwards, I want the values in [Quantity CF] to be like that displayed in the outlined box.

      Untitled.png

      But instead, this is how it shows up. It is pulling in 50 from the [Stock] measure, but I want it to pull in the value 20 from the previous week, even though the week is not on display.

       

      Thanks for your help, and please find the attached workbook.

       

      Thanks,
      Shantanu