IPivotClass.Total

The method is used in transformation formulas of analytical data area calculated elements. Only name of the Total method without the PivotClass class is specified in formula equations. Calling of the method from macros in Fore is not supported.

When the Total method is used as a function in formula expressions, take the following into account:

If the calculated element is located in columns and the function is set with the Column Totals parameter, or the calculated element is located in rows and the function is set with the Row Totals parameter:

If the Total function is set for the current dimension element without specifying the particular element in the formula, and the appropriate total method is calculated for the table, the grand total will be calculated by this element.
If a new calculated element was added, and a formula is not calculated for it where the total could be taken, value of the Total function by this calculated element will be empty.
If another element is specified for the calculated element in the formula, the grand total will be calculated by the specified element.

If the calculated element is located in columns and the function is set with the Row Totals parameter, or the calculated element is located in rows and the function is set with the Column Totals parameter, value of the calculated element will correspond to value of the grand total by rows or columns, respectively.

If the total by rows or columns is not calculated, the corresponding function set in the formulas returns empty value.

The mandatory requirement for method working is enabling calculation of required totals for table rows or columns. If totals are not calculated, the method returns empty values.

The Relation parameter is optional. If the parameter is not specified, the method returns total of the element, after which calculated element is created. As a value of the Relation parameter, it is required to specify element of the dimension, for which a calculated element is created. On specifying the Relation parameter the method returns the grand total calculated by the specified element.

The Position parameter is optional. If the parameter is not specified, or the value matches the location of created element, the method returns total of the element, for which transformation formula is set. If the value is specified that is opposite to calculated element location (the calculated element is located by columns, and the PivotTotalPosition.Rows value is specified, and vice versa), the method returns total value by rows/columns respectively.

Example of Use in Expressions

Result: the grand total located by rows as a sum of corresponding dimensions located above the calculated element.

IPivotClass.Total

Syntax

Parameters

Description

Comments

Example of Use in Expressions