5 Replies Latest reply: May 4, 2012 3:23 AM by Gijs Spruijt RSS

    How-To: Repeat First Opening Value in another column

    Gijs Spruijt

      Hi there

       

      I need to perform a calculation based on Closing Value, accumulation of the Purchases and Sales, and the First Opening Value based on the Date Selection.
      I have tried functions and Set Analysis and get get anything to bring the value down?
      My last Alternative would be to only have a year to date static graph.
      Attached is the model. I want the "Open" value to be repeated in the "First Open Val" and change when the Dimesnion changes.
      (Please note that it is also not necessarily the smallest value)

       

      Thanks