3 Replies Latest reply: Aug 19, 2011 4:57 AM by Bikash Debnath RSS

    totaling across columns in a pivot table

      Is there a simple way to calculate a total across multiple columns in a pivot table.  See attached screen shot.  I am hoping that I can add a total column that will total the billed, backlog, 90 day and forecast columns to get a total potential revenue.  I would also use the same thing to calculate the variance column which would be the budget less the other columns.  I am guessing that I could combine all the calculations for each column but they are fairly complicated and I would prefer not to induce that kind of potential error in the calculations.