new MiscellaneousOptions()
The MiscellaneousOptions object defines the control's default miscellaneous options, hold by misc field of the Pivot.Options. The miscellaneous options include various settings that control the behavior and appearance of the pivot table, such as the captions for empty pivot rows or columns. The control's miscellaneous options are defined by the MiscellaneousOptions object, which is hold by the misc field of the Pivot.Options class. Each miscellaneous option can be set to a specific value to customize the behavior and appearance of the pivot table. For instance, you can set the columnEmptyPivotRows and rowEmptyPivotRows fields to customize the captions for empty pivot rows or columns. By default, the columnEmptyPivotRows field is set to "*", and the rowEmptyPivotRows field is set to "Total". This means that when no pivot rows are defined, the first column will have the caption "*", and the single row will have the caption "Total". You can change these captions by setting the columnEmptyPivotRows and rowEmptyPivotRows fields to different values.
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. By default, the columnEmptyPivotRows field is set to "*", and the rowEmptyPivotRows field is set to "Total". This means that when no pivot rows are defined, the first column will have the caption "*", and the single row will have the caption "Total". You can customize these captions by setting the columnEmptyPivotRows and rowEmptyPivotRows fields to different values.
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. By default, the columnEmptyPivotRows field is set to "*", and the rowEmptyPivotRows field is set to "Total". This means that when no pivot rows are defined, the first column will have the caption "*", and the single row will have the caption "Total". You can customize these captions by setting the columnEmptyPivotRows and rowEmptyPivotRows fields to different values.
Type:
- string
Example
"" {string}, defines an empty caption
"Total" {string}, specifies the caption for the single row when no pivot rows are set (default)