PPLPivotTableTotalsSettings

Syntax

PPLPivotTableTotalsSettings()

Example

The example of use is given in the Working with Data Table Totals Settings section.

Syntax

virtual SPPLPivotTableTotalsTypes columnTypes() const

Example

The example of use is given in the Working with Data Table Totals Settings section.

Syntax

SNID copy()

Example

The example of use is given in the Working with Data Table Totals Settings section.

Syntax

virtual bool isEmpty() const

Comments

Available values:

• true. Totals settings are determined.

• false. Totals settings are not determined.

Example

The example of use is given in the Working with Data Table Totals Settings section.

Syntax

virtual bool isIncludeParents() const

Comments

Available values:

• true. Parent element values are taken into account on totals calculation.

• false. Parent element values are not taken into account.

Example

The example of use is given in the Working with Data Table Totals Settings section.

Syntax

virtual bool isTreatEmptyAsZero() const

Comments

The method is relevant on calculating specific types of totals that take into account the number of element in the period, for example, Average.

Available values:

• true. Empty cells are treated as zeros.

• false. Empty cells are not treated as zeros.

Example

The example of use is given in the Working with Data Table Totals Settings section.

Syntax

virtual bool isUseHierarchy() const

Comments

The hierarchy of one table element, for example, country is taken into account on totals calculation.

Available values:

• true. Hierarchy in table headers is taken into account on totals calculation.

• false. Hierarchy is not taken into account.

Example

The example of use is given in the Working with Data Table Totals Settings section.

Syntax

virtual bool isUseHierarchy() const

Comments

Hierarchy of all table objects, for example, countries, is taken into account on totals calculation.

Available values:

• true. Nesting level in table headers is taken into account on totals calculation.

• false. Nesting level is not taken into account.

Example

The example of use is given in the Working with Data Table Totals Settings section.

Syntax

virtual SPPLPivotTableTotalsTypes rowTypes() const

Example

The example of use is given in the Working with Data Table Totals Settings section.

Syntax

virtual void setIncludeParents(bool value)

Parameters

value. Indicates whether parent element data is taken into account. Available values:

• true. Parent element values are taken into account on totals calculation.

• false. Parent element values are not taken into account.

Example

The example of use is given in the Working with Data Table Totals Settings section.

Syntax

virtual void setTreatEmptyAsZero(bool value)

Parameters

value. Mode value.

Comments

The method is relevant on calculating specific types of totals that take into account the number of element in the period, for example, Average.

Available values:

• true. Empty cells are treated as zeros.

• false. Empty cells are not treated as zeros.

Example

The example of use is given in the Working with Data Table Totals Settings section.

Syntax

virtual void setUseHierarchy(bool value)

Parameters

value. Mode value.

Comments

The hierarchy of one table element, for example, country is taken into account on totals calculation.

Available values:

• true. Hierarchy in table headers is taken into account on totals calculation.

• false. Hierarchy is not taken into account.

Example

The example of use is given in the Working with Data Table Totals Settings section.

Syntax

virtual void setUseLevels(bool value)

Parameters

value. Mode value.

Comments

Hierarchy of all table objects, for example, countries, is taken into account on totals calculation.

Available values:

• true. Nesting level in table headers is taken into account on totals calculation.

• false. Nesting level is not taken into account.

Example

The example of use is given in the Working with Data Table Totals Settings section.