3 Replies Latest reply on Oct 31, 2018 2:45 AM by Simon Runc

    If dimension has x value, convert to y.

    Anita Lee

      This is what I have, with Hour in Rows and Units in Measure Values:

      Hour Units

      8       10

      9       2

      10       11

      11       1

      12       10

      13       2

      14       11

      15       1

       

      I would like to see this:

      8       12

      10       12

      12       12

      14       12

       

      How can I combine 8 and 9 into an aggregate sum with label of 8?