checked and replicate the variance from the findings of the user to find out if the report is the problem JDA & Pentaho data, meeting discussion with sir Jimmy, modified the reports fixed the grouping