I modified the query and tested the application again, as per checking, the gross sale changed but there are still discrepancies, rechecked the data, per checking, the cause of it is the return for other sale time is not extracted, as per checking of the query, it is using the correct filter and it should be extracted.