We use some estimate data (example Labor Cost (rate x hours)) from the beginning of a pay period, posted through batches and with various other details and categorizations to reflect in different reports, throughout the pay period.
Before generating the pay roll, we revert all estimates to net-zero and load actual hours reported and run our processes. The report shows all records i.e. estimates, reversals and actuals.
We want to filter out all the net-zero records (i.e. estimates and reversals) and see only the actuals. We tried to see the metrics in a pivot measure, where in addition to canceling +, -ve costs it sums up various costs while keeping the total value true, we want to see all discrete records for actuals (without aggregation). Any input is highly appreciated.