4 Replies Latest reply: Jun 10, 2013 7:58 AM by Miles Newey RSS

    Totals on Pivots

      Morning All,

       

      Please can someone explain this one for me. I have a pivot table, and the first column shown here in the picture has the expression =AVG(BudgUC) . Now granted I have show partial sums ticked and on, but why is this total at the basic level not right? Surely it should be 14.38 not 16.53??? HELP!!!!

       

      Capture.PNG

       

      Kind Regards,

       

      Miles