AddFields
function AddFields(
options: object = null,
options.rows: number | string | number[] | string[] = null,
options.columns: number | string | number[] | string[] = null,
options.pages: number | string | number[] | string[] = null,
options.addToTable: boolean = null,
): voidDescription
Adds row, column, and page fields to a PivotTable report.
Parameters
- options
objectdefault: null - options.rows
number | string | number[] | string[]default: null Specifies an array of field names or ids to be added as rows or added to the category axis.
- options.columns
number | string | number[] | string[]default: null Specifies an array of field names or ids to be added as columns or added to the series axis.
- options.pages
number | string | number[] | string[]default: null Specifies an array of field names or ids to be added as pages or added to the page area.
- options.addToTable
booleandefault: null Applies only to PivotTable reports. True to add the specified fields to the report (none of the existing fields are replaced). False to replace existing fields with the new fields. The default value is False.
Returns
void