3.2.3.1.8 Pivot Formulas

  • Article

Pivot formulas are used to define calculated items or calculated fields for PivotTables.

Pivot formulas shall not use user-defined names.

A pivot formula shall not use array constants.

A pivot formula shall not use cell references.

A pivot formula shall not use structure references.

A pivot formula shall not use calls to the following worksheet functions: GETPIVOTDATA, DCOUNT, DCOUNTA, DSUM, DAVERAGE, DMIN, DMAX, DPRODUCT, DSTDEV, DSTDEVP, DVAR, DVARP, INDEX, RAND, NOW, AREAS, ROWS, COLUMNS, OFFSET, CELL, INDIRECT, TODAY, INFO, and RANDBETWEEN.

A pivot formula shall not use calls to user-defined functions.