new MiscellaneousOptions()
The MiscellaneousOptions object defines the control's default miscellaneous options, hold by misc option of the Pivot.Options
For instance, the "rowEmptyPivotRows" option:
misc: { rowEmptyPivotRows: "" }sets the row caption when no pivot rows are specified.
- Since:
- 4.2
Members
(static) columnEmptyPivotRows :string
The columnEmptyPivotRows field defines the caption of the first column when no pivot rows are set. The rowEmptyPivotRows field specifies the caption for the single row when no pivot rows are specified. In this case, the pivot columns determine the aggregate functions applied to the entire dataset without grouping by pivot rows.
Type:
- string
Example
"" {string}, defines an empty caption (default)
"*" {string}, specifies the caption for the first-column when no pivot rows are defined(static) rowEmptyPivotRows :string
The rowEmptyPivotRows field specifies the caption for the single row when no pivot rows are set, while the columnEmptyPivotRows field defines the caption of the first column in this scenario. In this case, the pivot columns determine the aggregate functions applied to the entire dataset without grouping by pivot rows.
Type:
- string
Example
"" {string}, defines an empty caption
"Total" {string}, specifies the caption for the single row when no pivot rows are set (default)