# PivotTableSortConfigurationProperty

The sort configuration for a `PivotTableVisual` .

- Source: Generated code
- Type last changed: v2.93.0 · 23 Aug 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 pivotTableSortConfigurationProperty: quicksight.CfnAnalysis.PivotTableSortConfigurationProperty = {
  fieldSortOptions: [{
    fieldId: 'fieldId',
    sortBy: {
      column: {
        direction: 'direction',
        sortBy: {
          columnName: 'columnName',

          // the properties below are optional
          dataSetIdentifier: 'dataSetIdentifier',
          topicIdentifier: 'topicIdentifier',
        },

        // the properties below are optional
        aggregationFunction: {
          attributeAggregationFunction: {
            simpleAttributeAggregation: 'simpleAttributeAggregation',
            valueForMultipleValues: 'valueForMultipleValues',
          },
          categoricalAggregationFunction: 'categoricalAggregationFunction',
          dateAggregationFunction: 'dateAggregationFunction',
          numericalAggregationFunction: {
            percentileAggregation: {
              percentileValue: 123,
            },
            simpleNumericalAggregation: 'simpleNumericalAggregation',
          },
        },
      },
      dataPath: {
        direction: 'direction',
        sortPaths: [{
          dataPathType: {
            pivotTableDataPathType: 'pivotTableDataPathType',
          },
          fieldId: 'fieldId',
          fieldValue: 'fieldValue',
        }],
      },
      field: {
        direction: 'direction',
        fieldId: 'fieldId',
      },
    },
  }],
};
```

## Properties

- `fieldSortOptions`: [IResolvable](/cdk/api/v2/docs/aws-cdk-lib.IResolvable.html) | [IResolvable](/cdk/api/v2/docs/aws-cdk-lib.IResolvable.html) | [CfnAnalysis.PivotFieldSortOptionsProperty](/cdk/api/v2/docs/aws-cdk-lib.aws_quicksight.CfnAnalysis.PivotFieldSortOptionsProperty.html)[] — The field sort options for a pivot table sort configuration.