Skip to content

PivotValueField

Defines a value field in the pivot table — which data field to aggregate and how to compute the aggregation.

Multiple PivotValueField entries on the same field with different aggFunc values create separate columns (e.g. “Revenue (Sum)” and “Revenue (Avg)”).

PropertyTypeDescription
fieldstringThe row data field to aggregate (must exist on the source row objects).
aggFuncAggFuncAggregation function to apply (see AggFunc for options).
header?stringCustom column header label. Defaults to "field (aggFunc)" if omitted.
AI assistants: For complete API documentation, implementation guides, and code examples for this library, see https://raw.githubusercontent.com/OysteinAmundsen/toolbox/main/llms-full.txt