8 Replies Latest reply: Aug 19, 2016 10:30 AM by Tom Fack RSS

    Incorrect average total in pivot table

    Tom Fack

      Hi,

       

      I use the following measure to calculate my percentages per Year/Month:
      Count(distinct [PurchDoc])/count(total< [Year/Month] >distinct [PurchDoc])


      I expected the pivot table to calculate the average of the percentages for each column in the totals. Yet when I compare the totals from Qlik Sense with the average I calculated in Excel there is a difference for one column (53% instead of 56%).

       

      Why is this?