4 Replies Latest reply: Dec 12, 2017 3:53 AM by Christopher Ellis RSS

    Pivot Table Totals

    Christopher Ellis

      Could some one shed some light on this.

       

      The attached table is a pivot table and shows the totals for each subdivision.

       

      What I am seeing is that the subdivisions are totalling differently.

       

      I have highlighted in yellow the 2 columns that total the top figure but the first highlighted column doesn't total up correctly.

       

      244.8+223.5 should be 468 and it is 244.5 the second highlighted column does this correctly 167.0 +201.5 = 368.5

       

      Any advice appreciated.

       

      Chris