For the subtotals I have running totals that are reset at the same group level (group level 1), these work fine and I recieve the correct amounts per group.
The running totals that I have for the grand totals appear to be out of scope and is selecting all records because it cannot tally the reset amounts obtained in the subtotals.
Row level data:
ID Job# Activated Revoked
121345 34 True True
121345 19 False True
The Activated and Revoked columns are summed if they are true.
The group level is based on the ID.
Activated: 1
Revoked: 1
Total Activated: 98
Total Revoked: 209