I'm trying to create a usage report for a customer that tells how many of each product they've ordered in the last year. So I need to have a total when sorted by a part number.
Heres what it looks like unsorted
Sorted by Product ID with a "Trailing Group by Product:ID"
As you hopefully can see, the Total does not compute correctly
This is what it looks like behind the scenes- Maybe the problem is that its running a Trailing subtotal COUNT as opposed to a TOTAL? But I'm not able to select "TOTAL"...