3 Replies Latest reply on Jul 5, 2018 5:03 AM by Zhouyi Zhang

    Displaying the Sum of a Field as a Row Value

    James Taylor

      I have a field in my database which displays whether a customer was active or not in the first 10 days. In the database there is a unique line of data for each day for each customer. I want to be able to view the data in the following way, but all I can get the data to display is a sum of all the active days. (The active days column is either a 1 or a 0)

       

      Here is a sample of what the data looks like:

       

        

      User IDActive in the First 10 Days
      100011
      100011
      100011
      100011
      100010
      100010
      100010
      100010
      100010
      100010
      100010
      100010
      100010
      100010
      100011
      100021
      100021
      100021
      100020
      100020
      100020
      100020
      100031
      100031
      100031
      100031
      100031
      100031
      100031
      100031
      100031
      100031
      100030
      100041
      100051
      100050
      100051
      100050
      100051
      100050
      100051
      100051
      100050
      100050
      100050
      100061
      100061
      100061
      100061
      100071
      100070

       

      This is is how I would like to display the data:

       

        

      Number of Active DaysCount of Users
      12
      20
      31
      41
      52
      60
      70
      80
      90
      101

       

      Please can anybody offer a suggestion of what I need to do to view the data in this way?

       

      Thanks