This content has been marked as final. Show 4 replies
A simplified version of what I am trying to accomplish:
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,