13 Replies Latest reply on Mar 10, 2016 7:40 AM by beverly

    Report

    KAtieNeal-Rizzo

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