Discussed with sir Ian data again, for checking where the data he give came from, as per sir Ian, it is from the database, from the valid_tickets table, and the application query is extracting from the sale_line_items table, checked both tables, as per the checking, it is returning the same output, Included Pentaho team on the meeting for confirming the table to used, as per Mark, both tables are OK to used, as the sale_line_items is a detailed table and the valid_tickets is a summary table. Did not change the table where the data is extracted, and checked the possible cause of why the return transaction is not extracted in the application, as per checking, the cause is a promotion_id, and it is included in the filter, confirmed to sir Ian if this should be included, as per sir Ian, it should not for return as this is Employee discount and employee discount should not be returned.