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.