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

    Above() or below() functions

    Aidan O Reilly

      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.

       

      Thanks,

      Aidan

         

      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