跳到主要内容

PivotTableFieldOptions

The settings for adding row, column, and page fields to the pivot table report.

Type

Object

Properties

NameTypeDescription
addToTablebooleanSpecifies whether to apply fields only to the pivot table reports. If true, the specified fields will be added to the report \ without replacing existing fields. If false, existing fields will be replaced with the new fields.
columnsnumber | string | number[] | string[]An array of field names or IDs to be added as columns or added to the series axis.
pagesnumber | string | number[] | string[]An array of field names or IDs to be added as pages or added to the page area.
rowsnumber | string | number[] | string[]An array of field names or IDs to be added as rows or added to the category axis.