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

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.

• totaling across columns in a pivot table

Is Billed, Backlog, 90 day and forcast dimension members or expressions?  I see a variance calc so I cant tell if they are expressions or dimension members

• totaling across columns in a pivot table

create  variable using the settings>variable overview option for each of the expressions.. like Var1 will have the expression of Billed, Var2 will have the expression of Backlog... and similarly the others.. and..  create a new expression and add all the four variables.. \$(Var1) + \$(Var2) + ....

hope this helps..

• Re: totaling across columns in a pivot table

If you just want to add values from all 5 columns and then create a 6th column,

say,consider the second row in the pivot table,

70,000+30,000+ 0 + 27,000+0

then just write this in the expression for 6th column as

Column(1)+Column(2)+Column(3)+Column(4)+Column(5), you will get the result as \$127,000.

But if you are looking for something else, I assume you will need to explain you problem further.

Regards,

Bikash