15 Replies Latest reply: Jun 16, 2016 4:04 PM by Sunny Talwar RSS

    Total does not add up while using Distinct count function

    Vish Pattanashetty

      Notice the pivot below. The sum of the columns does not add up to the total. This is because I am using this function to count for the details Count( Distinct [field]) however when it comes to the totals, it creates a different combination of distinct numbers so it produces that.

       

      How do i make the totals just the summation of the details above and to the right while at the same time, keep the details with the same formula as Distinct count?

       

      Untitled.png