15 Replies Latest reply: Aug 30, 2017 2:45 PM by Rob Wunderlich RSS

    Totals on Pivot table are incorrect

    Celia Seward

      The pivot table has 1 row,  2 columns and 1 measure.  The row is School Building, the 2 columns are School Year and Therapy Type.  The measure function looks like this:


      count(distinct if ( (consult + individual + direct)>0,studentid))


      the function counts the studentids who received Consult, Individual or Direct services


      The totals by School Building are correct, but the grand totals are not.


      Any help is surely appreciated.