32 Replies Latest reply: Jul 13, 2016 8:17 PM by Vish Pattanashetty RSS

    Totals don't add up in Pivot Table

    Vish Pattanashetty

      Please take a look at this pivot table. The individual numbers are correct. But the Totals do not add up. The formula I have for calculating individual numbers is Count(Distinct upper([Unique Report])). How do I get the totals to agree? I have also attached the excel version.

       

      Capture.PNG

       

      stalwar1 can you help?