Hi readers!,

I have a data group report where I need to count how distinct shipments I made, but I don't know how to create a variable that only increments when a data group changes. Important do not use a view.

My table:
shipment lot qty
1511 123A 210
1511 121 100
1512 125 300
1513 145 300
1513 124 280

I got the next result in my report

Shipment qty
1511 310
1512 300
1513 580

Total Shipments -> 5 (wrong must be 3 !)
Qty -> 1190

Regards
Martin