interface PivotTableConfigurationProperty
| Language | Type name |
|---|---|
 .NET | Amazon.CDK.AWS.QuickSight.CfnDashboard.PivotTableConfigurationProperty |
 Java | software.amazon.awscdk.services.quicksight.CfnDashboard.PivotTableConfigurationProperty |
 Python | aws_cdk.aws_quicksight.CfnDashboard.PivotTableConfigurationProperty |
 TypeScript | @aws-cdk/aws-quicksight » CfnDashboard » PivotTableConfigurationProperty |
The configuration for a PivotTableVisual .
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 pivotTableConfigurationProperty: quicksight.CfnDashboard.PivotTableConfigurationProperty = {
fieldOptions: {
dataPathOptions: [{
dataPathList: [{
fieldId: 'fieldId',
fieldValue: 'fieldValue',
}],
// the properties below are optional
width: 'width',
}],
selectedFieldOptions: [{
fieldId: 'fieldId',
// the properties below are optional
customLabel: 'customLabel',
visibility: 'visibility',
}],
},
fieldWells: {
pivotTableAggregatedFieldWells: {
columns: [{
categoricalDimensionField: {
column: {
columnName: 'columnName',
dataSetIdentifier: 'dataSetIdentifier',
},
fieldId: 'fieldId',
// the properties below are optional
formatConfiguration: {
nullValueFormatConfiguration: {
nullString: 'nullString',
},
numericFormatConfiguration: {
currencyDisplayFormatConfiguration: {
decimalPlacesConfiguration: {
decimalPlaces: 123,
},
negativeValueConfiguration: {
displayMode: 'displayMode',
},
nullValueFormatConfiguration: {
nullString: 'nullString',
},
numberScale: 'numberScale',
prefix: 'prefix',
separatorConfiguration: {
decimalSeparator: 'decimalSeparator',
thousandsSeparator: {
symbol: 'symbol',
visibility: 'visibility',
},
},
suffix: 'suffix',
symbol: 'symbol',
},
numberDisplayFormatConfiguration: {
decimalPlacesConfiguration: {
decimalPlaces: 123,
},
negativeValueConfiguration: {
displayMode: 'displayMode',
},
nullValueFormatConfiguration: {
nullString: 'nullString',
},
numberScale: 'numberScale',
prefix: 'prefix',
separatorConfiguration: {
decimalSeparator: 'decimalSeparator',
thousandsSeparator: {
symbol: 'symbol',
visibility: 'visibility',
},
},
suffix: 'suffix',
},
percentageDisplayFormatConfiguration: {
decimalPlacesConfiguration: {
decimalPlaces: 123,
},
negativeValueConfiguration: {
displayMode: 'displayMode',
},
nullValueFormatConfiguration: {
nullString: 'nullString',
},
prefix: 'prefix',
separatorConfiguration: {
decimalSeparator: 'decimalSeparator',
thousandsSeparator: {
symbol: 'symbol',
visibility: 'visibility',
},
},
suffix: 'suffix',
},
},
},
hierarchyId: 'hierarchyId',
},
dateDimensionField: {
column: {
columnName: 'columnName',
dataSetIdentifier: 'dataSetIdentifier',
},
fieldId: 'fieldId',
// the properties below are optional
dateGranularity: 'dateGranularity',
formatConfiguration: {
dateTimeFormat: 'dateTimeFormat',
nullValueFormatConfiguration: {
nullString: 'nullString',
},
numericFormatConfiguration: {
currencyDisplayFormatConfiguration: {
decimalPlacesConfiguration: {
decimalPlaces: 123,
},
negativeValueConfiguration: {
displayMode: 'displayMode',
},
nullValueFormatConfiguration: {
nullString: 'nullString',
},
numberScale: 'numberScale',
prefix: 'prefix',
separatorConfiguration: {
decimalSeparator: 'decimalSeparator',
thousandsSeparator: {
symbol: 'symbol',
visibility: 'visibility',
},
},
suffix: 'suffix',
symbol: 'symbol',
},
numberDisplayFormatConfiguration: {
decimalPlacesConfiguration: {
decimalPlaces: 123,
},
negativeValueConfiguration: {
displayMode: 'displayMode',
},
nullValueFormatConfiguration: {
nullString: 'nullString',
},
numberScale: 'numberScale',
prefix: 'prefix',
separatorConfiguration: {
decimalSeparator: 'decimalSeparator',
thousandsSeparator: {
symbol: 'symbol',
visibility: 'visibility',
},
},
suffix: 'suffix',
},
percentageDisplayFormatConfiguration: {
decimalPlacesConfiguration: {
decimalPlaces: 123,
},
negativeValueConfiguration: {
displayMode: 'displayMode',
},
nullValueFormatConfiguration: {
nullString: 'nullString',
},
prefix: 'prefix',
separatorConfiguration: {
decimalSeparator: 'decimalSeparator',
thousandsSeparator: {
symbol: 'symbol',
visibility: 'visibility',
},
},
suffix: 'suffix',
},
},
},
hierarchyId: 'hierarchyId',
},
numericalDimensionField: {
column: {
columnName: 'columnName',
dataSetIdentifier: 'dataSetIdentifier',
},
fieldId: 'fieldId',
// the properties below are optional
formatConfiguration: {
formatConfiguration: {
currencyDisplayFormatConfiguration: {
decimalPlacesConfiguration: {
decimalPlaces: 123,
},
negativeValueConfiguration: {
displayMode: 'displayMode',
},
nullValueFormatConfiguration: {
nullString: 'nullString',
},
numberScale: 'numberScale',
prefix: 'prefix',
separatorConfiguration: {
decimalSeparator: 'decimalSeparator',
thousandsSeparator: {
symbol: 'symbol',
visibility: 'visibility',
},
},
suffix: 'suffix',
symbol: 'symbol',
},
numberDisplayFormatConfiguration: {
decimalPlacesConfiguration: {
decimalPlaces: 123,
},
negativeValueConfiguration: {
displayMode: 'displayMode',
},
nullValueFormatConfiguration: {
nullString: 'nullString',
},
numberScale: 'numberScale',
prefix: 'prefix',
separatorConfiguration: {
decimalSeparator: 'decimalSeparator',
thousandsSeparator: {
symbol: 'symbol',
visibility: 'visibility',
},
},
suffix: 'suffix',
},
percentageDisplayFormatConfiguration: {
decimalPlacesConfiguration: {
decimalPlaces: 123,
},
negativeValueConfiguration: {
displayMode: 'displayMode',
},
nullValueFormatConfiguration: {
nullString: 'nullString',
},
prefix: 'prefix',
separatorConfiguration: {
decimalSeparator: 'decimalSeparator',
thousandsSeparator: {
symbol: 'symbol',
visibility: 'visibility',
},
},
suffix: 'suffix',
},
},
},
hierarchyId: 'hierarchyId',
},
}],
rows: [{
categoricalDimensionField: {
column: {
columnName: 'columnName',
dataSetIdentifier: 'dataSetIdentifier',
},
fieldId: 'fieldId',
// the properties below are optional
formatConfiguration: {
nullValueFormatConfiguration: {
nullString: 'nullString',
},
numericFormatConfiguration: {
currencyDisplayFormatConfiguration: {
decimalPlacesConfiguration: {
decimalPlaces: 123,
},
negativeValueConfiguration: {
displayMode: 'displayMode',
},
nullValueFormatConfiguration: {
nullString: 'nullString',
},
numberScale: 'numberScale',
prefix: 'prefix',
separatorConfiguration: {
decimalSeparator: 'decimalSeparator',
thousandsSeparator: {
symbol: 'symbol',
visibility: 'visibility',
},
},
suffix: 'suffix',
symbol: 'symbol',
},
numberDisplayFormatConfiguration: {
decimalPlacesConfiguration: {
decimalPlaces: 123,
},
negativeValueConfiguration: {
displayMode: 'displayMode',
},
nullValueFormatConfiguration: {
nullString: 'nullString',
},
numberScale: 'numberScale',
prefix: 'prefix',
separatorConfiguration: {
decimalSeparator: 'decimalSeparator',
thousandsSeparator: {
symbol: 'symbol',
visibility: 'visibility',
},
},
suffix: 'suffix',
},
percentageDisplayFormatConfiguration: {
decimalPlacesConfiguration: {
decimalPlaces: 123,
},
negativeValueConfiguration: {
displayMode: 'displayMode',
},
nullValueFormatConfiguration: {
nullString: 'nullString',
},
prefix: 'prefix',
separatorConfiguration: {
decimalSeparator: 'decimalSeparator',
thousandsSeparator: {
symbol: 'symbol',
visibility: 'visibility',
},
},
suffix: 'suffix',
},
},
},
hierarchyId: 'hierarchyId',
},
dateDimensionField: {
column: {
columnName: 'columnName',
dataSetIdentifier: 'dataSetIdentifier',
},
fieldId: 'fieldId',
// the properties below are optional
dateGranularity: 'dateGranularity',
formatConfiguration: {
dateTimeFormat: 'dateTimeFormat',
nullValueFormatConfiguration: {
nullString: 'nullString',
},
numericFormatConfiguration: {
currencyDisplayFormatConfiguration: {
decimalPlacesConfiguration: {
decimalPlaces: 123,
},
negativeValueConfiguration: {
displayMode: 'displayMode',
},
nullValueFormatConfiguration: {
nullString: 'nullString',
},
numberScale: 'numberScale',
prefix: 'prefix',
separatorConfiguration: {
decimalSeparator: 'decimalSeparator',
thousandsSeparator: {
symbol: 'symbol',
visibility: 'visibility',
},
},
suffix: 'suffix',
symbol: 'symbol',
},
numberDisplayFormatConfiguration: {
decimalPlacesConfiguration: {
decimalPlaces: 123,
},
negativeValueConfiguration: {
displayMode: 'displayMode',
},
nullValueFormatConfiguration: {
nullString: 'nullString',
},
numberScale: 'numberScale',
prefix: 'prefix',
separatorConfiguration: {
decimalSeparator: 'decimalSeparator',
thousandsSeparator: {
symbol: 'symbol',
visibility: 'visibility',
},
},
suffix: 'suffix',
},
percentageDisplayFormatConfiguration: {
decimalPlacesConfiguration: {
decimalPlaces: 123,
},
negativeValueConfiguration: {
displayMode: 'displayMode',
},
nullValueFormatConfiguration: {
nullString: 'nullString',
},
prefix: 'prefix',
separatorConfiguration: {
decimalSeparator: 'decimalSeparator',
thousandsSeparator: {
symbol: 'symbol',
visibility: 'visibility',
},
},
suffix: 'suffix',
},
},
},
hierarchyId: 'hierarchyId',
},
numericalDimensionField: {
column: {
columnName: 'columnName',
dataSetIdentifier: 'dataSetIdentifier',
},
fieldId: 'fieldId',
// the properties below are optional
formatConfiguration: {
formatConfiguration: {
currencyDisplayFormatConfiguration: {
decimalPlacesConfiguration: {
decimalPlaces: 123,
},
negativeValueConfiguration: {
displayMode: 'displayMode',
},
nullValueFormatConfiguration: {
nullString: 'nullString',
},
numberScale: 'numberScale',
prefix: 'prefix',
separatorConfiguration: {
decimalSeparator: 'decimalSeparator',
thousandsSeparator: {
symbol: 'symbol',
visibility: 'visibility',
},
},
suffix: 'suffix',
symbol: 'symbol',
},
numberDisplayFormatConfiguration: {
decimalPlacesConfiguration: {
decimalPlaces: 123,
},
negativeValueConfiguration: {
displayMode: 'displayMode',
},
nullValueFormatConfiguration: {
nullString: 'nullString',
},
numberScale: 'numberScale',
prefix: 'prefix',
separatorConfiguration: {
decimalSeparator: 'decimalSeparator',
thousandsSeparator: {
symbol: 'symbol',
visibility: 'visibility',
},
},
suffix: 'suffix',
},
percentageDisplayFormatConfiguration: {
decimalPlacesConfiguration: {
decimalPlaces: 123,
},
negativeValueConfiguration: {
displayMode: 'displayMode',
},
nullValueFormatConfiguration: {
nullString: 'nullString',
},
prefix: 'prefix',
separatorConfiguration: {
decimalSeparator: 'decimalSeparator',
thousandsSeparator: {
symbol: 'symbol',
visibility: 'visibility',
},
},
suffix: 'suffix',
},
},
},
hierarchyId: 'hierarchyId',
},
}],
values: [{
calculatedMeasureField: {
expression: 'expression',
fieldId: 'fieldId',
},
categoricalMeasureField: {
column: {
columnName: 'columnName',
dataSetIdentifier: 'dataSetIdentifier',
},
fieldId: 'fieldId',
// the properties below are optional
aggregationFunction: 'aggregationFunction',
formatConfiguration: {
nullValueFormatConfiguration: {
nullString: 'nullString',
},
numericFormatConfiguration: {
currencyDisplayFormatConfiguration: {
decimalPlacesConfiguration: {
decimalPlaces: 123,
},
negativeValueConfiguration: {
displayMode: 'displayMode',
},
nullValueFormatConfiguration: {
nullString: 'nullString',
},
numberScale: 'numberScale',
prefix: 'prefix',
separatorConfiguration: {
decimalSeparator: 'decimalSeparator',
thousandsSeparator: {
symbol: 'symbol',
visibility: 'visibility',
},
},
suffix: 'suffix',
symbol: 'symbol',
},
numberDisplayFormatConfiguration: {
decimalPlacesConfiguration: {
decimalPlaces: 123,
},
negativeValueConfiguration: {
displayMode: 'displayMode',
},
nullValueFormatConfiguration: {
nullString: 'nullString',
},
numberScale: 'numberScale',
prefix: 'prefix',
separatorConfiguration: {
decimalSeparator: 'decimalSeparator',
thousandsSeparator: {
symbol: 'symbol',
visibility: 'visibility',
},
},
suffix: 'suffix',
},
percentageDisplayFormatConfiguration: {
decimalPlacesConfiguration: {
decimalPlaces: 123,
},
negativeValueConfiguration: {
displayMode: 'displayMode',
},
nullValueFormatConfiguration: {
nullString: 'nullString',
},
prefix: 'prefix',
separatorConfiguration: {
decimalSeparator: 'decimalSeparator',
thousandsSeparator: {
symbol: 'symbol',
visibility: 'visibility',
},
},
suffix: 'suffix',
},
},
},
},
dateMeasureField: {
column: {
columnName: 'columnName',
dataSetIdentifier: 'dataSetIdentifier',
},
fieldId: 'fieldId',
// the properties below are optional
aggregationFunction: 'aggregationFunction',
formatConfiguration: {
dateTimeFormat: 'dateTimeFormat',
nullValueFormatConfiguration: {
nullString: 'nullString',
},
numericFormatConfiguration: {
currencyDisplayFormatConfiguration: {
decimalPlacesConfiguration: {
decimalPlaces: 123,
},
negativeValueConfiguration: {
displayMode: 'displayMode',
},
nullValueFormatConfiguration: {
nullString: 'nullString',
},
numberScale: 'numberScale',
prefix: 'prefix',
separatorConfiguration: {
decimalSeparator: 'decimalSeparator',
thousandsSeparator: {
symbol: 'symbol',
visibility: 'visibility',
},
},
suffix: 'suffix',
symbol: 'symbol',
},
numberDisplayFormatConfiguration: {
decimalPlacesConfiguration: {
decimalPlaces: 123,
},
negativeValueConfiguration: {
displayMode: 'displayMode',
},
nullValueFormatConfiguration: {
nullString: 'nullString',
},
numberScale: 'numberScale',
prefix: 'prefix',
separatorConfiguration: {
decimalSeparator: 'decimalSeparator',
thousandsSeparator: {
symbol: 'symbol',
visibility: 'visibility',
},
},
suffix: 'suffix',
},
percentageDisplayFormatConfiguration: {
decimalPlacesConfiguration: {
decimalPlaces: 123,
},
negativeValueConfiguration: {
displayMode: 'displayMode',
},
nullValueFormatConfiguration: {
nullString: 'nullString',
},
prefix: 'prefix',
separatorConfiguration: {
decimalSeparator: 'decimalSeparator',
thousandsSeparator: {
symbol: 'symbol',
visibility: 'visibility',
},
},
suffix: 'suffix',
},
},
},
},
numericalMeasureField: {
column: {
columnName: 'columnName',
dataSetIdentifier: 'dataSetIdentifier',
},
fieldId: 'fieldId',
// the properties below are optional
aggregationFunction: {
percentileAggregation: {
percentileValue: 123,
},
simpleNumericalAggregation: 'simpleNumericalAggregation',
},
formatConfiguration: {
formatConfiguration: {
currencyDisplayFormatConfiguration: {
decimalPlacesConfiguration: {
decimalPlaces: 123,
},
negativeValueConfiguration: {
displayMode: 'displayMode',
},
nullValueFormatConfiguration: {
nullString: 'nullString',
},
numberScale: 'numberScale',
prefix: 'prefix',
separatorConfiguration: {
decimalSeparator: 'decimalSeparator',
thousandsSeparator: {
symbol: 'symbol',
visibility: 'visibility',
},
},
suffix: 'suffix',
symbol: 'symbol',
},
numberDisplayFormatConfiguration: {
decimalPlacesConfiguration: {
decimalPlaces: 123,
},
negativeValueConfiguration: {
displayMode: 'displayMode',
},
nullValueFormatConfiguration: {
nullString: 'nullString',
},
numberScale: 'numberScale',
prefix: 'prefix',
separatorConfiguration: {
decimalSeparator: 'decimalSeparator',
thousandsSeparator: {
symbol: 'symbol',
visibility: 'visibility',
},
},
suffix: 'suffix',
},
percentageDisplayFormatConfiguration: {
decimalPlacesConfiguration: {
decimalPlaces: 123,
},
negativeValueConfiguration: {
displayMode: 'displayMode',
},
nullValueFormatConfiguration: {
nullString: 'nullString',
},
prefix: 'prefix',
separatorConfiguration: {
decimalSeparator: 'decimalSeparator',
thousandsSeparator: {
symbol: 'symbol',
visibility: 'visibility',
},
},
suffix: 'suffix',
},
},
},
},
}],
},
},
paginatedReportOptions: {
overflowColumnHeaderVisibility: 'overflowColumnHeaderVisibility',
verticalOverflowVisibility: 'verticalOverflowVisibility',
},
sortConfiguration: {
fieldSortOptions: [{
fieldId: 'fieldId',
sortBy: {
column: {
direction: 'direction',
sortBy: {
columnName: 'columnName',
dataSetIdentifier: 'dataSetIdentifier',
},
// the properties below are optional
aggregationFunction: {
categoricalAggregationFunction: 'categoricalAggregationFunction',
dateAggregationFunction: 'dateAggregationFunction',
numericalAggregationFunction: {
percentileAggregation: {
percentileValue: 123,
},
simpleNumericalAggregation: 'simpleNumericalAggregation',
},
},
},
dataPath: {
direction: 'direction',
sortPaths: [{
fieldId: 'fieldId',
fieldValue: 'fieldValue',
}],
},
field: {
direction: 'direction',
fieldId: 'fieldId',
},
},
}],
},
tableOptions: {
cellStyle: {
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',
},
columnHeaderStyle: {
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',
},
columnNamesVisibility: 'columnNamesVisibility',
metricPlacement: 'metricPlacement',
rowAlternateColorOptions: {
rowAlternateColors: ['rowAlternateColors'],
status: 'status',
},
rowFieldNamesStyle: {
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',
},
rowHeaderStyle: {
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',
},
singleMetricVisibility: 'singleMetricVisibility',
toggleButtonsVisibility: 'toggleButtonsVisibility',
},
totalOptions: {
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 |
|---|---|---|
| field | IResolvable | Pivot | The field options for a pivot table visual. |
| field | IResolvable | Pivot | The field wells of the visual. |
| paginated | IResolvable | Pivot | The paginated report options for a pivot table visual. |
| sort | IResolvable | Pivot | The sort configuration for a PivotTableVisual . |
| table | IResolvable | Pivot | The table options for a pivot table visual. |
| total | IResolvable | Pivot | The total options for a pivot table visual. |
fieldOptions?
Type:
IResolvable | Pivot
(optional)
The field options for a pivot table visual.
fieldWells?
Type:
IResolvable | Pivot
(optional)
The field wells of the visual.
paginatedReportOptions?
Type:
IResolvable | Pivot
(optional)
The paginated report options for a pivot table visual.
sortConfiguration?
Type:
IResolvable | Pivot
(optional)
The sort configuration for a PivotTableVisual .
tableOptions?
Type:
IResolvable | Pivot
(optional)
The table options for a pivot table visual.
totalOptions?
Type:
IResolvable | Pivot
(optional)
The total options for a pivot table visual.