4 Replies Latest reply: Mar 22, 2017 6:23 PM by Elise Reiter RSS

    Column total in pivot table not summing properly

    Elise Reiter

      Hello,

       

      I have built the pivot table in the screen shot attached (sample pivot table) and the column totals are not summing as I'd like them to.

       

      The measure in the pivot table is [Total A]+[Total B] which are columns from two different excel sheets and where Total A and Total B are already sums of various other columns within the excel document. For example Total A = Sum(D5+E5) on Spreadsheet A and Total B =Sum(D5+E5) on Spreadsheet B.

       

      Is there a way I can change the measure in the pivot table so that the top row "3B" displays a sum of the rows beneath it?