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.