# PivotTotalOptionsProperty

The optional configuration of totals cells in a `PivotTableVisual` .

- Source: Generated code
- Type last changed: v2.103.0 · 26 Oct 2023

## 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 pivotTotalOptionsProperty: quicksight.CfnAnalysis.PivotTotalOptionsProperty = {
  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',
      fontFamily: 'fontFamily',
      fontSize: {
        absolute: 'absolute',
        relative: 'relative',
      },
      fontStyle: 'fontStyle',
      fontWeight: {
        name: 'name',
      },
    },
    height: 123,
    horizontalTextAlignment: 'horizontalTextAlignment',
    textWrap: 'textWrap',
    verticalTextAlignment: 'verticalTextAlignment',
    visibility: 'visibility',
  },
  placement: 'placement',
  scrollStatus: 'scrollStatus',
  totalAggregationOptions: [{
    fieldId: 'fieldId',
    totalAggregationFunction: {
      simpleTotalAggregationFunction: 'simpleTotalAggregationFunction',
    },
  }],
  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',
      fontFamily: 'fontFamily',
      fontSize: {
        absolute: 'absolute',
        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',
      fontFamily: 'fontFamily',
      fontSize: {
        absolute: 'absolute',
        relative: 'relative',
      },
      fontStyle: 'fontStyle',
      fontWeight: {
        name: 'name',
      },
    },
    height: 123,
    horizontalTextAlignment: 'horizontalTextAlignment',
    textWrap: 'textWrap',
    verticalTextAlignment: 'verticalTextAlignment',
    visibility: 'visibility',
  },
};
```

## Properties

- `customLabel`: string — The custom label string for the total cells.

- `metricHeaderCellStyle`: [IResolvable](/cdk/api/v2/docs/aws-cdk-lib.IResolvable.html) | [CfnAnalysis.TableCellStyleProperty](/cdk/api/v2/docs/aws-cdk-lib.aws_quicksight.CfnAnalysis.TableCellStyleProperty.html) — The cell styling options for the total of header cells.

- `placement`: string — The placement (start, end) for the total cells.

- `scrollStatus`: string — The scroll status (pinned, scrolled) for the total cells.

- `totalAggregationOptions`: [IResolvable](/cdk/api/v2/docs/aws-cdk-lib.IResolvable.html) | [IResolvable](/cdk/api/v2/docs/aws-cdk-lib.IResolvable.html) | [CfnAnalysis.TotalAggregationOptionProperty](/cdk/api/v2/docs/aws-cdk-lib.aws_quicksight.CfnAnalysis.TotalAggregationOptionProperty.html)[] — The total aggregation options for each value field.

- `totalCellStyle`: [IResolvable](/cdk/api/v2/docs/aws-cdk-lib.IResolvable.html) | [CfnAnalysis.TableCellStyleProperty](/cdk/api/v2/docs/aws-cdk-lib.aws_quicksight.CfnAnalysis.TableCellStyleProperty.html) — The cell styling options for the total cells.

- `totalsVisibility`: string — The visibility configuration for the total cells.

- `valueCellStyle`: [IResolvable](/cdk/api/v2/docs/aws-cdk-lib.IResolvable.html) | [CfnAnalysis.TableCellStyleProperty](/cdk/api/v2/docs/aws-cdk-lib.aws_quicksight.CfnAnalysis.TableCellStyleProperty.html) — The cell styling options for the totals of value cells.