OfficeWriter Documentation
.
ExcelWriter v8 Docs
Space Shortcuts
Page tree
ConfigureSpace tools

Versions Compared

Old Version 15

changes.mady.by.user Sam Haddad [softartisans]

Saved on

compared with

New Version Current

changes.mady.by.user Alison Bird [softartisans]

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin
Description
Introducedin
8.34
8.34
Description

Excerpt

Sets or returns the type of calculation used to summarize a data field. The available types are determined by PivotTableField.SummarizeByType.

...

Remarks

Data fields are set to 'count' for string values and 'sum' for numerical values by defaultSUM' by default for all data types.

This property cannot be set on values labels and such fields will return SummarizeByType.Sum by default. You can check if a PivotTable field is values label with the IsValuesLabel property