simple expressions

[#1]

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.

[sebastiandperei · Accepted solution]

Matt,

In first place, if your expression label has special characters (in this case, the space in Total Value), you must use []

For example: [Total Value]+[Overhead]

In second place, you can't use Sum([Total Value]), because [Total Values] is only a value, the result of the expression in this cell of the table. You only can use the label (or column()) in arithmetic operations, or with OTHER expression.

For Example: [Total Value] + Avg(Tax)

[#3]

Thanks, Sebastian! That worked for me. No wonder I could never get it to work before. Here you go, Matt.

[#4]

Ditto, that worked.   Thank you all for being so helpful (and patient).

Matt