6 Replies Latest reply: Nov 9, 2015 11:02 AM by Aidan O Reilly RSS

    Above() or below() functions

      Hi there


      I want to create a chart as per the below, I have the user, date and the volume per day.


      But in the MTD column I need to have 61+71 in row 2 for example.

      In row 3 its the sum of 71+61+75 and so on.


      Is this possible?

      I have tried above and below functions but cannot seem to achieve this.





      User DateVolumeTotal MTD
      User 101/11/20157171
      User 102/11/201561132
      User 103/11/201575207
      User 104/11/201556263
      User 105/11/201555318
      User 106/11/201574392