We use some estimate data (example Labor Cost (rate x hours)) at 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 worked 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 other costs (not listed with distinct, unique attribute, as expected in a pivot) while keeping the total value true. We want to see all discrete records for actuals (without aggregation). Any input is highly appreciated.
