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

    Previous week's value, without displaying week

    Shantanu Mendhekar



      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.


      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.