matrix report not summing correctly

• Nomvula

  Hall of Fame

  Points: 3778

  More actions

  September 20, 2010 at 5:49 am

  #229419

  hi

  i have the following data in a table below: and i've created a matrix report where in the column i'll have weekNumber field and Data field i should have sum of MeterReading. how do i make my data field to only sum based on distinct WorkOrderCode, the Sum should be 95000 and not 280000.

  WorkOrderCode WeekNumber MeterReading

  D0001 36 50000

  D0001 36 50000

  D0002 36 45000

  D0002 36 45000

  D0002 36 45000

  D0002 36 45000

• Daniel Bowlin

  SSC-Dedicated

  Points: 34566

  More actions

  September 20, 2010 at 7:03 am

  #1223985

  Is there a reason you can't group the data in your dataset?