checked the Pentaho ETL workback and the sales per day report to figure out the variance of two reports, some transactions not loaded on Pentaho alternative solutions manually trigger a sales refresh for idept tiffany & location RCC Makati only as filter parameters, advised Arvin to check again