The optional configuration of totals cells in a PivotTableVisual.
Syntax
To declare this entity in your AWS CloudFormation template, use the following syntax:
JSON
{
"CustomLabel" : String,
"MetricHeaderCellStyle" : TableCellStyle,
"Placement" : String,
"ScrollStatus" : String,
"TotalAggregationOptions" : [ TotalAggregationOption, ... ],
"TotalCellStyle" : TableCellStyle,
"TotalsVisibility" : String,
"ValueCellStyle" : TableCellStyle
}
YAML
CustomLabel: String
MetricHeaderCellStyle:
TableCellStyle
Placement: String
ScrollStatus: String
TotalAggregationOptions:
- TotalAggregationOption
TotalCellStyle:
TableCellStyle
TotalsVisibility: String
ValueCellStyle:
TableCellStyle
Properties
CustomLabel-
The custom label string for the total cells.
Required: No
Type: String
Update requires: No interruption
MetricHeaderCellStyle-
The cell styling options for the total of header cells.
Required: No
Type: TableCellStyle
Update requires: No interruption
Placement-
The placement (start, end) for the total cells.
Required: No
Type: String
Allowed values:
START | END | AUTOUpdate requires: No interruption
ScrollStatus-
The scroll status (pinned, scrolled) for the total cells.
Required: No
Type: String
Allowed values:
PINNED | SCROLLEDUpdate requires: No interruption
TotalAggregationOptions-
The total aggregation options for each value field.
Required: No
Type: Array of TotalAggregationOption
Minimum:
0Maximum:
200Update requires: No interruption
TotalCellStyle-
The cell styling options for the total cells.
Required: No
Type: TableCellStyle
Update requires: No interruption
TotalsVisibility-
The visibility configuration for the total cells.
Required: No
Type: String
Allowed values:
HIDDEN | VISIBLEUpdate requires: No interruption
ValueCellStyle-
The cell styling options for the totals of value cells.
Required: No
Type: TableCellStyle
Update requires: No interruption
