Skip to content
v2.274.0

PivotTableOptionsProperty Struct ​

The table options for a pivot table visual.

Example ​

ts
// The code below shows an example of how to instantiate this type.
// The values are placeholders you should change.
import { aws_quicksight as quicksight } from 'aws-cdk-lib';
const pivotTableOptionsProperty: quicksight.CfnTemplate.PivotTableOptionsProperty = {
  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',
      fontFamily: 'fontFamily',
      fontSize: {
        absolute: 'absolute',
        relative: 'relative',
      },
      fontStyle: 'fontStyle',
      fontWeight: {
        name: 'name',
      },
    },
    height: 123,
    horizontalTextAlignment: 'horizontalTextAlignment',
    textWrap: 'textWrap',
    verticalTextAlignment: 'verticalTextAlignment',
    visibility: 'visibility',
  },
  collapsedRowDimensionsVisibility: 'collapsedRowDimensionsVisibility',
  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',
      fontFamily: 'fontFamily',
      fontSize: {
        absolute: 'absolute',
        relative: 'relative',
      },
      fontStyle: 'fontStyle',
      fontWeight: {
        name: 'name',
      },
    },
    height: 123,
    horizontalTextAlignment: 'horizontalTextAlignment',
    textWrap: 'textWrap',
    verticalTextAlignment: 'verticalTextAlignment',
    visibility: 'visibility',
  },
  columnNamesVisibility: 'columnNamesVisibility',
  defaultCellWidth: 'defaultCellWidth',
  metricPlacement: 'metricPlacement',
  rowAlternateColorOptions: {
    rowAlternateColors: ['rowAlternateColors'],
    status: 'status',
    usePrimaryBackgroundColor: 'usePrimaryBackgroundColor',
  },
  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',
      fontFamily: 'fontFamily',
      fontSize: {
        absolute: 'absolute',
        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',
      fontFamily: 'fontFamily',
      fontSize: {
        absolute: 'absolute',
        relative: 'relative',
      },
      fontStyle: 'fontStyle',
      fontWeight: {
        name: 'name',
      },
    },
    height: 123,
    horizontalTextAlignment: 'horizontalTextAlignment',
    textWrap: 'textWrap',
    verticalTextAlignment: 'verticalTextAlignment',
    visibility: 'visibility',
  },
  rowsLabelOptions: {
    customLabel: 'customLabel',
    visibility: 'visibility',
  },
  rowsLayout: 'rowsLayout',
  singleMetricVisibility: 'singleMetricVisibility',
  toggleButtonsVisibility: 'toggleButtonsVisibility',
};

Properties ​

cellStyleoptionalIResolvable | CfnTemplate.TableCellStylePropertycell_styleoptionaltyping.Union[IResolvable, TableCellStyleProperty]cellStyleoptionalIResolvableCellStyleoptionalIResolvableCellStyleoptionalinterface{}#
The table cell style of cells.
collapsedRowDimensionsVisibilityoptionalstringcollapsed_row_dimensions_visibilityoptionalstrcollapsedRowDimensionsVisibilityoptionalStringCollapsedRowDimensionsVisibilityoptionalstringCollapsedRowDimensionsVisibilityoptional*string#
The visibility setting of a pivot table's collapsed row dimension fields.

If the value of this structure is HIDDEN , all collapsed columns in a pivot table are automatically hidden. The default value is VISIBLE .

columnHeaderStyleoptionalIResolvable | CfnTemplate.TableCellStylePropertycolumn_header_styleoptionaltyping.Union[IResolvable, TableCellStyleProperty]columnHeaderStyleoptionalIResolvableColumnHeaderStyleoptionalIResolvableColumnHeaderStyleoptionalinterface{}#
The table cell style of the column header.
columnNamesVisibilityoptionalstringcolumn_names_visibilityoptionalstrcolumnNamesVisibilityoptionalStringColumnNamesVisibilityoptionalstringColumnNamesVisibilityoptional*string#
The visibility of the column names.
defaultCellWidthoptionalstringdefault_cell_widthoptionalstrdefaultCellWidthoptionalStringDefaultCellWidthoptionalstringDefaultCellWidthoptional*string#
The default cell width of the pivot table.
metricPlacementoptionalstringmetric_placementoptionalstrmetricPlacementoptionalStringMetricPlacementoptionalstringMetricPlacementoptional*string#
The metric placement (row, column) options.
rowAlternateColorOptionsoptionalIResolvable | CfnTemplate.RowAlternateColorOptionsPropertyrow_alternate_color_optionsoptionaltyping.Union[IResolvable, RowAlternateColorOptionsProperty]rowAlternateColorOptionsoptionalIResolvableRowAlternateColorOptionsoptionalIResolvableRowAlternateColorOptionsoptionalinterface{}#
The row alternate color options (widget status, row alternate colors).
rowFieldNamesStyleoptionalIResolvable | CfnTemplate.TableCellStylePropertyrow_field_names_styleoptionaltyping.Union[IResolvable, TableCellStyleProperty]rowFieldNamesStyleoptionalIResolvableRowFieldNamesStyleoptionalIResolvableRowFieldNamesStyleoptionalinterface{}#
The table cell style of row field names.
rowHeaderStyleoptionalIResolvable | CfnTemplate.TableCellStylePropertyrow_header_styleoptionaltyping.Union[IResolvable, TableCellStyleProperty]rowHeaderStyleoptionalIResolvableRowHeaderStyleoptionalIResolvableRowHeaderStyleoptionalinterface{}#
The table cell style of the row headers.
rowsLabelOptionsoptionalIResolvable | CfnTemplate.PivotTableRowsLabelOptionsPropertyrows_label_optionsoptionaltyping.Union[IResolvable, PivotTableRowsLabelOptionsProperty]rowsLabelOptionsoptionalIResolvableRowsLabelOptionsoptionalIResolvableRowsLabelOptionsoptionalinterface{}#
The options for the label that is located above the row headers.

This option is only applicable when RowsLayout is set to HIERARCHY .

rowsLayoutoptionalstringrows_layoutoptionalstrrowsLayoutoptionalStringRowsLayoutoptionalstringRowsLayoutoptional*string#
The layout for the row dimension headers of a pivot table. Choose one of the following options.
  • TABULAR : (Default) Each row field is displayed in a separate column.
  • HIERARCHY : All row fields are displayed in a single column. Indentation is used to differentiate row headers of different fields.
singleMetricVisibilityoptionalstringsingle_metric_visibilityoptionalstrsingleMetricVisibilityoptionalStringSingleMetricVisibilityoptionalstringSingleMetricVisibilityoptional*string#
The visibility of the single metric options.
toggleButtonsVisibilityoptionalstringtoggle_buttons_visibilityoptionalstrtoggleButtonsVisibilityoptionalStringToggleButtonsVisibilityoptionalstringToggleButtonsVisibilityoptional*string#
Determines the visibility of the pivot table.