12 Replies Latest reply: Aug 30, 2012 2:40 PM by Matt Johnson RSS

    simple expressions

      I have a pivot table with three expressions.  I would like to sum together the result of these three expressions into a new 4th expression.  Is there a way to pull the results from the first three into the new expression, or do i just have to replicate the first three computations inside the new expression?

       

      for example:

       

      A+B=C

      X-Y=D

      K(5)/X=M

       

      I would like to learn how to write an expression C+D+M.

       

      Or is there a better way to get it into the pivot table other than an expression?  Be gentle I am just an accountant.  I see some of the questions some of you post and it looks like hieroglyphs.....and very impressive ones at that.

       

      Thank you in advance for any replys.