interface PivotTableTotalOptionsProperty
| Language | Type name |
|---|---|
 .NET | Amazon.CDK.AWS.QuickSight.CfnDashboard.PivotTableTotalOptionsProperty |
 Java | software.amazon.awscdk.services.quicksight.CfnDashboard.PivotTableTotalOptionsProperty |
 Python | aws_cdk.aws_quicksight.CfnDashboard.PivotTableTotalOptionsProperty |
 TypeScript | @aws-cdk/aws-quicksight » CfnDashboard » PivotTableTotalOptionsProperty |
The total options for a pivot table visual.
Example
// The code below shows an example of how to instantiate this type.
// The values are placeholders you should change.
import * as quicksight from '@aws-cdk/aws-quicksight';
const pivotTableTotalOptionsProperty: quicksight.CfnDashboard.PivotTableTotalOptionsProperty = {
columnSubtotalOptions: {
customLabel: 'customLabel',
fieldLevel: 'fieldLevel',
fieldLevelOptions: [{
fieldId: 'fieldId',
}],
metricHeaderCellStyle: {
backgroundColor: 'backgroundColor',
border: {
sideSpecificBorder: {
bottom: {
color: 'color',
style: 'style',
thickness: 123,
},
innerHorizontal: {
color: 'color',
style: 'style',
thickness: 123,
},
innerVertical: {
color: 'color',
style: 'style',
thickness: 123,
},
left: {
color: 'color',
style: 'style',
thickness: 123,
},
right: {
color: 'color',
style: 'style',
thickness: 123,
},
top: {
color: 'color',
style: 'style',
thickness: 123,
},
},
uniformBorder: {
color: 'color',
style: 'style',
thickness: 123,
},
},
fontConfiguration: {
fontColor: 'fontColor',
fontDecoration: 'fontDecoration',
fontSize: {
relative: 'relative',
},
fontStyle: 'fontStyle',
fontWeight: {
name: 'name',
},
},
height: 123,
horizontalTextAlignment: 'horizontalTextAlignment',
textWrap: 'textWrap',
verticalTextAlignment: 'verticalTextAlignment',
visibility: 'visibility',
},
totalCellStyle: {
backgroundColor: 'backgroundColor',
border: {
sideSpecificBorder: {
bottom: {
color: 'color',
style: 'style',
thickness: 123,
},
innerHorizontal: {
color: 'color',
style: 'style',
thickness: 123,
},
innerVertical: {
color: 'color',
style: 'style',
thickness: 123,
},
left: {
color: 'color',
style: 'style',
thickness: 123,
},
right: {
color: 'color',
style: 'style',
thickness: 123,
},
top: {
color: 'color',
style: 'style',
thickness: 123,
},
},
uniformBorder: {
color: 'color',
style: 'style',
thickness: 123,
},
},
fontConfiguration: {
fontColor: 'fontColor',
fontDecoration: 'fontDecoration',
fontSize: {
relative: 'relative',
},
fontStyle: 'fontStyle',
fontWeight: {
name: 'name',
},
},
height: 123,
horizontalTextAlignment: 'horizontalTextAlignment',
textWrap: 'textWrap',
verticalTextAlignment: 'verticalTextAlignment',
visibility: 'visibility',
},
totalsVisibility: 'totalsVisibility',
valueCellStyle: {
backgroundColor: 'backgroundColor',
border: {
sideSpecificBorder: {
bottom: {
color: 'color',
style: 'style',
thickness: 123,
},
innerHorizontal: {
color: 'color',
style: 'style',
thickness: 123,
},
innerVertical: {
color: 'color',
style: 'style',
thickness: 123,
},
left: {
color: 'color',
style: 'style',
thickness: 123,
},
right: {
color: 'color',
style: 'style',
thickness: 123,
},
top: {
color: 'color',
style: 'style',
thickness: 123,
},
},
uniformBorder: {
color: 'color',
style: 'style',
thickness: 123,
},
},
fontConfiguration: {
fontColor: 'fontColor',
fontDecoration: 'fontDecoration',
fontSize: {
relative: 'relative',
},
fontStyle: 'fontStyle',
fontWeight: {
name: 'name',
},
},
height: 123,
horizontalTextAlignment: 'horizontalTextAlignment',
textWrap: 'textWrap',
verticalTextAlignment: 'verticalTextAlignment',
visibility: 'visibility',
},
},
columnTotalOptions: {
customLabel: 'customLabel',
metricHeaderCellStyle: {
backgroundColor: 'backgroundColor',
border: {
sideSpecificBorder: {
bottom: {
color: 'color',
style: 'style',
thickness: 123,
},
innerHorizontal: {
color: 'color',
style: 'style',
thickness: 123,
},
innerVertical: {
color: 'color',
style: 'style',
thickness: 123,
},
left: {
color: 'color',
style: 'style',
thickness: 123,
},
right: {
color: 'color',
style: 'style',
thickness: 123,
},
top: {
color: 'color',
style: 'style',
thickness: 123,
},
},
uniformBorder: {
color: 'color',
style: 'style',
thickness: 123,
},
},
fontConfiguration: {
fontColor: 'fontColor',
fontDecoration: 'fontDecoration',
fontSize: {
relative: 'relative',
},
fontStyle: 'fontStyle',
fontWeight: {
name: 'name',
},
},
height: 123,
horizontalTextAlignment: 'horizontalTextAlignment',
textWrap: 'textWrap',
verticalTextAlignment: 'verticalTextAlignment',
visibility: 'visibility',
},
placement: 'placement',
scrollStatus: 'scrollStatus',
totalCellStyle: {
backgroundColor: 'backgroundColor',
border: {
sideSpecificBorder: {
bottom: {
color: 'color',
style: 'style',
thickness: 123,
},
innerHorizontal: {
color: 'color',
style: 'style',
thickness: 123,
},
innerVertical: {
color: 'color',
style: 'style',
thickness: 123,
},
left: {
color: 'color',
style: 'style',
thickness: 123,
},
right: {
color: 'color',
style: 'style',
thickness: 123,
},
top: {
color: 'color',
style: 'style',
thickness: 123,
},
},
uniformBorder: {
color: 'color',
style: 'style',
thickness: 123,
},
},
fontConfiguration: {
fontColor: 'fontColor',
fontDecoration: 'fontDecoration',
fontSize: {
relative: 'relative',
},
fontStyle: 'fontStyle',
fontWeight: {
name: 'name',
},
},
height: 123,
horizontalTextAlignment: 'horizontalTextAlignment',
textWrap: 'textWrap',
verticalTextAlignment: 'verticalTextAlignment',
visibility: 'visibility',
},
totalsVisibility: 'totalsVisibility',
valueCellStyle: {
backgroundColor: 'backgroundColor',
border: {
sideSpecificBorder: {
bottom: {
color: 'color',
style: 'style',
thickness: 123,
},
innerHorizontal: {
color: 'color',
style: 'style',
thickness: 123,
},
innerVertical: {
color: 'color',
style: 'style',
thickness: 123,
},
left: {
color: 'color',
style: 'style',
thickness: 123,
},
right: {
color: 'color',
style: 'style',
thickness: 123,
},
top: {
color: 'color',
style: 'style',
thickness: 123,
},
},
uniformBorder: {
color: 'color',
style: 'style',
thickness: 123,
},
},
fontConfiguration: {
fontColor: 'fontColor',
fontDecoration: 'fontDecoration',
fontSize: {
relative: 'relative',
},
fontStyle: 'fontStyle',
fontWeight: {
name: 'name',
},
},
height: 123,
horizontalTextAlignment: 'horizontalTextAlignment',
textWrap: 'textWrap',
verticalTextAlignment: 'verticalTextAlignment',
visibility: 'visibility',
},
},
rowSubtotalOptions: {
customLabel: 'customLabel',
fieldLevel: 'fieldLevel',
fieldLevelOptions: [{
fieldId: 'fieldId',
}],
metricHeaderCellStyle: {
backgroundColor: 'backgroundColor',
border: {
sideSpecificBorder: {
bottom: {
color: 'color',
style: 'style',
thickness: 123,
},
innerHorizontal: {
color: 'color',
style: 'style',
thickness: 123,
},
innerVertical: {
color: 'color',
style: 'style',
thickness: 123,
},
left: {
color: 'color',
style: 'style',
thickness: 123,
},
right: {
color: 'color',
style: 'style',
thickness: 123,
},
top: {
color: 'color',
style: 'style',
thickness: 123,
},
},
uniformBorder: {
color: 'color',
style: 'style',
thickness: 123,
},
},
fontConfiguration: {
fontColor: 'fontColor',
fontDecoration: 'fontDecoration',
fontSize: {
relative: 'relative',
},
fontStyle: 'fontStyle',
fontWeight: {
name: 'name',
},
},
height: 123,
horizontalTextAlignment: 'horizontalTextAlignment',
textWrap: 'textWrap',
verticalTextAlignment: 'verticalTextAlignment',
visibility: 'visibility',
},
totalCellStyle: {
backgroundColor: 'backgroundColor',
border: {
sideSpecificBorder: {
bottom: {
color: 'color',
style: 'style',
thickness: 123,
},
innerHorizontal: {
color: 'color',
style: 'style',
thickness: 123,
},
innerVertical: {
color: 'color',
style: 'style',
thickness: 123,
},
left: {
color: 'color',
style: 'style',
thickness: 123,
},
right: {
color: 'color',
style: 'style',
thickness: 123,
},
top: {
color: 'color',
style: 'style',
thickness: 123,
},
},
uniformBorder: {
color: 'color',
style: 'style',
thickness: 123,
},
},
fontConfiguration: {
fontColor: 'fontColor',
fontDecoration: 'fontDecoration',
fontSize: {
relative: 'relative',
},
fontStyle: 'fontStyle',
fontWeight: {
name: 'name',
},
},
height: 123,
horizontalTextAlignment: 'horizontalTextAlignment',
textWrap: 'textWrap',
verticalTextAlignment: 'verticalTextAlignment',
visibility: 'visibility',
},
totalsVisibility: 'totalsVisibility',
valueCellStyle: {
backgroundColor: 'backgroundColor',
border: {
sideSpecificBorder: {
bottom: {
color: 'color',
style: 'style',
thickness: 123,
},
innerHorizontal: {
color: 'color',
style: 'style',
thickness: 123,
},
innerVertical: {
color: 'color',
style: 'style',
thickness: 123,
},
left: {
color: 'color',
style: 'style',
thickness: 123,
},
right: {
color: 'color',
style: 'style',
thickness: 123,
},
top: {
color: 'color',
style: 'style',
thickness: 123,
},
},
uniformBorder: {
color: 'color',
style: 'style',
thickness: 123,
},
},
fontConfiguration: {
fontColor: 'fontColor',
fontDecoration: 'fontDecoration',
fontSize: {
relative: 'relative',
},
fontStyle: 'fontStyle',
fontWeight: {
name: 'name',
},
},
height: 123,
horizontalTextAlignment: 'horizontalTextAlignment',
textWrap: 'textWrap',
verticalTextAlignment: 'verticalTextAlignment',
visibility: 'visibility',
},
},
rowTotalOptions: {
customLabel: 'customLabel',
metricHeaderCellStyle: {
backgroundColor: 'backgroundColor',
border: {
sideSpecificBorder: {
bottom: {
color: 'color',
style: 'style',
thickness: 123,
},
innerHorizontal: {
color: 'color',
style: 'style',
thickness: 123,
},
innerVertical: {
color: 'color',
style: 'style',
thickness: 123,
},
left: {
color: 'color',
style: 'style',
thickness: 123,
},
right: {
color: 'color',
style: 'style',
thickness: 123,
},
top: {
color: 'color',
style: 'style',
thickness: 123,
},
},
uniformBorder: {
color: 'color',
style: 'style',
thickness: 123,
},
},
fontConfiguration: {
fontColor: 'fontColor',
fontDecoration: 'fontDecoration',
fontSize: {
relative: 'relative',
},
fontStyle: 'fontStyle',
fontWeight: {
name: 'name',
},
},
height: 123,
horizontalTextAlignment: 'horizontalTextAlignment',
textWrap: 'textWrap',
verticalTextAlignment: 'verticalTextAlignment',
visibility: 'visibility',
},
placement: 'placement',
scrollStatus: 'scrollStatus',
totalCellStyle: {
backgroundColor: 'backgroundColor',
border: {
sideSpecificBorder: {
bottom: {
color: 'color',
style: 'style',
thickness: 123,
},
innerHorizontal: {
color: 'color',
style: 'style',
thickness: 123,
},
innerVertical: {
color: 'color',
style: 'style',
thickness: 123,
},
left: {
color: 'color',
style: 'style',
thickness: 123,
},
right: {
color: 'color',
style: 'style',
thickness: 123,
},
top: {
color: 'color',
style: 'style',
thickness: 123,
},
},
uniformBorder: {
color: 'color',
style: 'style',
thickness: 123,
},
},
fontConfiguration: {
fontColor: 'fontColor',
fontDecoration: 'fontDecoration',
fontSize: {
relative: 'relative',
},
fontStyle: 'fontStyle',
fontWeight: {
name: 'name',
},
},
height: 123,
horizontalTextAlignment: 'horizontalTextAlignment',
textWrap: 'textWrap',
verticalTextAlignment: 'verticalTextAlignment',
visibility: 'visibility',
},
totalsVisibility: 'totalsVisibility',
valueCellStyle: {
backgroundColor: 'backgroundColor',
border: {
sideSpecificBorder: {
bottom: {
color: 'color',
style: 'style',
thickness: 123,
},
innerHorizontal: {
color: 'color',
style: 'style',
thickness: 123,
},
innerVertical: {
color: 'color',
style: 'style',
thickness: 123,
},
left: {
color: 'color',
style: 'style',
thickness: 123,
},
right: {
color: 'color',
style: 'style',
thickness: 123,
},
top: {
color: 'color',
style: 'style',
thickness: 123,
},
},
uniformBorder: {
color: 'color',
style: 'style',
thickness: 123,
},
},
fontConfiguration: {
fontColor: 'fontColor',
fontDecoration: 'fontDecoration',
fontSize: {
relative: 'relative',
},
fontStyle: 'fontStyle',
fontWeight: {
name: 'name',
},
},
height: 123,
horizontalTextAlignment: 'horizontalTextAlignment',
textWrap: 'textWrap',
verticalTextAlignment: 'verticalTextAlignment',
visibility: 'visibility',
},
},
};
Properties
| Name | Type | Description |
|---|---|---|
| column | IResolvable | Subtotal | The column subtotal options. |
| column | IResolvable | Pivot | The column total options. |
| row | IResolvable | Subtotal | The row subtotal options. |
| row | IResolvable | Pivot | The row total options. |
columnSubtotalOptions?
Type:
IResolvable | Subtotal
(optional)
The column subtotal options.
columnTotalOptions?
Type:
IResolvable | Pivot
(optional)
The column total options.
rowSubtotalOptions?
Type:
IResolvable | Subtotal
(optional)
The row subtotal options.
rowTotalOptions?
Type:
IResolvable | Pivot
(optional)
The row total options.