Hello,

Within a report, I am trying to sum field1 based on when field2 changes.

Example:

Field1 Field2
1 222
1 222
1 222
12 111
12 111
12 111
6 444
6 444
---
19 Is the Quantity I am looking for. The sum option seems to sum every column. Any help would be appreciated.

Jeff