AnsweredAssumed Answered

Report

Question asked by KAtieNeal-Rizzo on Mar 9, 2016
Latest reply on Mar 10, 2016 by beverly

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"...

 

Outcomes