10 Replies Latest reply: Feb 8, 2017 6:04 PM by Sunny Talwar RSS

    Can't get proper unique ID count

    Michael Andrews

      I have  pivot table and I'm trying to count unique ids vs a form. However, my count is not coming out as expected. Can someone tell me what I'm missing? I'm using the formula Count(distinct ExamID)

       

      See attached for what my pivot table looks like.

       

      The sql equivalent would be SELECT COUNT(1) FROM Exam WHERE Exam_Form = 'Rev15_FormD' GROUP BY ExamID