I discussed with sir Law the findings in the data. As discussed while checking, the filter used in extracting the data for sales has a missing filter, meaning, the void and return transactions are not excluded in the transaction sales, and they should be excluded, advised that the query will be modified.