3 Replies Latest reply on Sep 3, 2012 6:15 AM by Jonathan Drummey

    Table Calculation- Sum a Category

      would like to sum only the first value of a measure. In my database the measure is duplicated multiple times for each customer.

       

       

      CustomerInvoice ValidationsAmount
      A110600
      A210400
      A310200
      B48300
      B58100
      C74200
      C64100

       

       

      For example for customer A I have 10 validations not 30. The total sum should display 22 not 54.I created a table calculation but the grand total is still displaying the incorrect value.