3 Replies Latest reply: Mar 15, 2018 10:21 AM by Youssef Belloum RSS

    Pivot table total column not correct

    Ashley Navin

      I have a pivot table that has 4 dimensions and I am showing partial sums on all the column. I can see the totals per column on the bottom and then i also have a total at the far right. The total at the far right does not equal the sum of all the column totals.

       

      I have pulled one dimension to the top, so it is breaking the columns up into the dimensions. I am attaching a picture of what the columns look like and the total.

       

       

       

      This is also happening on a less complex pivot table. See second attachment qlikview2. I am using distinct in my expressions in both charts could this be a factor?