4 Replies Latest reply: Nov 19, 2012 3:06 PM by Andrew Meyer RSS

    Summing all values with a date less than dimension

      A simplified version of what I am trying to accomplish:

       

      Data Sample:

       

      Date, Value       

      1/1/2012,10

      1/2/2012,20

      1/3/2012,30

      1/4/2012,90

      1/5/2012,100

       

      I would like to plot Date on the X Axis.  On the Y axis, I would like to plot the Sum of value where Date <= Dimension value.  For example:  on the date 1/4/2012, i would like to see the value 150.  On 1/2/2012, i would like to see 30.  If I click on a single date i should still be able to see the correct total (ie if i select and dispplay only 1/4/2012 I should still be able to see the value of 150)

       

      I have tried using TOTAL in my sum expressions, but this is plotting the total across all dimension values. 

       

      Please advise.  Thanks,


      Andrew