16 Replies Latest reply: Oct 3, 2017 1:17 PM by Celia Seward 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.

       

      Celia