From the Excel Help topic for "Syntax for calculated field and item formulas in PivotTable and PivotChart reports"...
Formula elements In formulas you create for<font color=red>calculated fields</font> and calculated items, you can use operators and expressions as you do in other worksheet formulas. You can use constants and refer to data from the report, but you cannot use cell references or defined names.<font color=red>You cannot use worksheet functions that require cell references</font> or defined names as parameters, and you cannot use array functions.
This message was edited by Mark W. on 2002-09-06 07:08