Show / Hide Table of Contents

Class CfnAnalysis.PivotTableConfigurationProperty

The configuration for a PivotTableVisual .

Inheritance
System.Object
CfnAnalysis.PivotTableConfigurationProperty
Implements
CfnAnalysis.IPivotTableConfigurationProperty
Namespace: Amazon.CDK.AWS.QuickSight
Assembly: Amazon.CDK.AWS.QuickSight.dll
Syntax (csharp)
public class PivotTableConfigurationProperty : Object, CfnAnalysis.IPivotTableConfigurationProperty
Syntax (vb)
Public Class PivotTableConfigurationProperty
    Inherits Object
    Implements CfnAnalysis.IPivotTableConfigurationProperty
Remarks

Link: http://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-properties-quicksight-analysis-pivottableconfiguration.html

ExampleMetadata: fixture=_generated

Examples
// The code below shows an example of how to instantiate this type.
// The values are placeholders you should change.
using Amazon.CDK.AWS.QuickSight;

var pivotTableConfigurationProperty = new PivotTableConfigurationProperty {
    FieldOptions = new PivotTableFieldOptionsProperty {
        DataPathOptions = new [] { new PivotTableDataPathOptionProperty {
            DataPathList = new [] { new DataPathValueProperty {
                FieldId = "fieldId",
                FieldValue = "fieldValue"
            } },

            // the properties below are optional
            Width = "width"
        } },
        SelectedFieldOptions = new [] { new PivotTableFieldOptionProperty {
            FieldId = "fieldId",

            // the properties below are optional
            CustomLabel = "customLabel",
            Visibility = "visibility"
        } }
    },
    FieldWells = new PivotTableFieldWellsProperty {
        PivotTableAggregatedFieldWells = new PivotTableAggregatedFieldWellsProperty {
            Columns = new [] { new DimensionFieldProperty {
                CategoricalDimensionField = new CategoricalDimensionFieldProperty {
                    Column = new ColumnIdentifierProperty {
                        ColumnName = "columnName",
                        DataSetIdentifier = "dataSetIdentifier"
                    },
                    FieldId = "fieldId",

                    // the properties below are optional
                    FormatConfiguration = new StringFormatConfigurationProperty {
                        NullValueFormatConfiguration = new NullValueFormatConfigurationProperty {
                            NullString = "nullString"
                        },
                        NumericFormatConfiguration = new NumericFormatConfigurationProperty {
                            CurrencyDisplayFormatConfiguration = new CurrencyDisplayFormatConfigurationProperty {
                                DecimalPlacesConfiguration = new DecimalPlacesConfigurationProperty {
                                    DecimalPlaces = 123
                                },
                                NegativeValueConfiguration = new NegativeValueConfigurationProperty {
                                    DisplayMode = "displayMode"
                                },
                                NullValueFormatConfiguration = new NullValueFormatConfigurationProperty {
                                    NullString = "nullString"
                                },
                                NumberScale = "numberScale",
                                Prefix = "prefix",
                                SeparatorConfiguration = new NumericSeparatorConfigurationProperty {
                                    DecimalSeparator = "decimalSeparator",
                                    ThousandsSeparator = new ThousandSeparatorOptionsProperty {
                                        Symbol = "symbol",
                                        Visibility = "visibility"
                                    }
                                },
                                Suffix = "suffix",
                                Symbol = "symbol"
                            },
                            NumberDisplayFormatConfiguration = new NumberDisplayFormatConfigurationProperty {
                                DecimalPlacesConfiguration = new DecimalPlacesConfigurationProperty {
                                    DecimalPlaces = 123
                                },
                                NegativeValueConfiguration = new NegativeValueConfigurationProperty {
                                    DisplayMode = "displayMode"
                                },
                                NullValueFormatConfiguration = new NullValueFormatConfigurationProperty {
                                    NullString = "nullString"
                                },
                                NumberScale = "numberScale",
                                Prefix = "prefix",
                                SeparatorConfiguration = new NumericSeparatorConfigurationProperty {
                                    DecimalSeparator = "decimalSeparator",
                                    ThousandsSeparator = new ThousandSeparatorOptionsProperty {
                                        Symbol = "symbol",
                                        Visibility = "visibility"
                                    }
                                },
                                Suffix = "suffix"
                            },
                            PercentageDisplayFormatConfiguration = new PercentageDisplayFormatConfigurationProperty {
                                DecimalPlacesConfiguration = new DecimalPlacesConfigurationProperty {
                                    DecimalPlaces = 123
                                },
                                NegativeValueConfiguration = new NegativeValueConfigurationProperty {
                                    DisplayMode = "displayMode"
                                },
                                NullValueFormatConfiguration = new NullValueFormatConfigurationProperty {
                                    NullString = "nullString"
                                },
                                Prefix = "prefix",
                                SeparatorConfiguration = new NumericSeparatorConfigurationProperty {
                                    DecimalSeparator = "decimalSeparator",
                                    ThousandsSeparator = new ThousandSeparatorOptionsProperty {
                                        Symbol = "symbol",
                                        Visibility = "visibility"
                                    }
                                },
                                Suffix = "suffix"
                            }
                        }
                    },
                    HierarchyId = "hierarchyId"
                },
                DateDimensionField = new DateDimensionFieldProperty {
                    Column = new ColumnIdentifierProperty {
                        ColumnName = "columnName",
                        DataSetIdentifier = "dataSetIdentifier"
                    },
                    FieldId = "fieldId",

                    // the properties below are optional
                    DateGranularity = "dateGranularity",
                    FormatConfiguration = new DateTimeFormatConfigurationProperty {
                        DateTimeFormat = "dateTimeFormat",
                        NullValueFormatConfiguration = new NullValueFormatConfigurationProperty {
                            NullString = "nullString"
                        },
                        NumericFormatConfiguration = new NumericFormatConfigurationProperty {
                            CurrencyDisplayFormatConfiguration = new CurrencyDisplayFormatConfigurationProperty {
                                DecimalPlacesConfiguration = new DecimalPlacesConfigurationProperty {
                                    DecimalPlaces = 123
                                },
                                NegativeValueConfiguration = new NegativeValueConfigurationProperty {
                                    DisplayMode = "displayMode"
                                },
                                NullValueFormatConfiguration = new NullValueFormatConfigurationProperty {
                                    NullString = "nullString"
                                },
                                NumberScale = "numberScale",
                                Prefix = "prefix",
                                SeparatorConfiguration = new NumericSeparatorConfigurationProperty {
                                    DecimalSeparator = "decimalSeparator",
                                    ThousandsSeparator = new ThousandSeparatorOptionsProperty {
                                        Symbol = "symbol",
                                        Visibility = "visibility"
                                    }
                                },
                                Suffix = "suffix",
                                Symbol = "symbol"
                            },
                            NumberDisplayFormatConfiguration = new NumberDisplayFormatConfigurationProperty {
                                DecimalPlacesConfiguration = new DecimalPlacesConfigurationProperty {
                                    DecimalPlaces = 123
                                },
                                NegativeValueConfiguration = new NegativeValueConfigurationProperty {
                                    DisplayMode = "displayMode"
                                },
                                NullValueFormatConfiguration = new NullValueFormatConfigurationProperty {
                                    NullString = "nullString"
                                },
                                NumberScale = "numberScale",
                                Prefix = "prefix",
                                SeparatorConfiguration = new NumericSeparatorConfigurationProperty {
                                    DecimalSeparator = "decimalSeparator",
                                    ThousandsSeparator = new ThousandSeparatorOptionsProperty {
                                        Symbol = "symbol",
                                        Visibility = "visibility"
                                    }
                                },
                                Suffix = "suffix"
                            },
                            PercentageDisplayFormatConfiguration = new PercentageDisplayFormatConfigurationProperty {
                                DecimalPlacesConfiguration = new DecimalPlacesConfigurationProperty {
                                    DecimalPlaces = 123
                                },
                                NegativeValueConfiguration = new NegativeValueConfigurationProperty {
                                    DisplayMode = "displayMode"
                                },
                                NullValueFormatConfiguration = new NullValueFormatConfigurationProperty {
                                    NullString = "nullString"
                                },
                                Prefix = "prefix",
                                SeparatorConfiguration = new NumericSeparatorConfigurationProperty {
                                    DecimalSeparator = "decimalSeparator",
                                    ThousandsSeparator = new ThousandSeparatorOptionsProperty {
                                        Symbol = "symbol",
                                        Visibility = "visibility"
                                    }
                                },
                                Suffix = "suffix"
                            }
                        }
                    },
                    HierarchyId = "hierarchyId"
                },
                NumericalDimensionField = new NumericalDimensionFieldProperty {
                    Column = new ColumnIdentifierProperty {
                        ColumnName = "columnName",
                        DataSetIdentifier = "dataSetIdentifier"
                    },
                    FieldId = "fieldId",

                    // the properties below are optional
                    FormatConfiguration = new NumberFormatConfigurationProperty {
                        FormatConfiguration = new NumericFormatConfigurationProperty {
                            CurrencyDisplayFormatConfiguration = new CurrencyDisplayFormatConfigurationProperty {
                                DecimalPlacesConfiguration = new DecimalPlacesConfigurationProperty {
                                    DecimalPlaces = 123
                                },
                                NegativeValueConfiguration = new NegativeValueConfigurationProperty {
                                    DisplayMode = "displayMode"
                                },
                                NullValueFormatConfiguration = new NullValueFormatConfigurationProperty {
                                    NullString = "nullString"
                                },
                                NumberScale = "numberScale",
                                Prefix = "prefix",
                                SeparatorConfiguration = new NumericSeparatorConfigurationProperty {
                                    DecimalSeparator = "decimalSeparator",
                                    ThousandsSeparator = new ThousandSeparatorOptionsProperty {
                                        Symbol = "symbol",
                                        Visibility = "visibility"
                                    }
                                },
                                Suffix = "suffix",
                                Symbol = "symbol"
                            },
                            NumberDisplayFormatConfiguration = new NumberDisplayFormatConfigurationProperty {
                                DecimalPlacesConfiguration = new DecimalPlacesConfigurationProperty {
                                    DecimalPlaces = 123
                                },
                                NegativeValueConfiguration = new NegativeValueConfigurationProperty {
                                    DisplayMode = "displayMode"
                                },
                                NullValueFormatConfiguration = new NullValueFormatConfigurationProperty {
                                    NullString = "nullString"
                                },
                                NumberScale = "numberScale",
                                Prefix = "prefix",
                                SeparatorConfiguration = new NumericSeparatorConfigurationProperty {
                                    DecimalSeparator = "decimalSeparator",
                                    ThousandsSeparator = new ThousandSeparatorOptionsProperty {
                                        Symbol = "symbol",
                                        Visibility = "visibility"
                                    }
                                },
                                Suffix = "suffix"
                            },
                            PercentageDisplayFormatConfiguration = new PercentageDisplayFormatConfigurationProperty {
                                DecimalPlacesConfiguration = new DecimalPlacesConfigurationProperty {
                                    DecimalPlaces = 123
                                },
                                NegativeValueConfiguration = new NegativeValueConfigurationProperty {
                                    DisplayMode = "displayMode"
                                },
                                NullValueFormatConfiguration = new NullValueFormatConfigurationProperty {
                                    NullString = "nullString"
                                },
                                Prefix = "prefix",
                                SeparatorConfiguration = new NumericSeparatorConfigurationProperty {
                                    DecimalSeparator = "decimalSeparator",
                                    ThousandsSeparator = new ThousandSeparatorOptionsProperty {
                                        Symbol = "symbol",
                                        Visibility = "visibility"
                                    }
                                },
                                Suffix = "suffix"
                            }
                        }
                    },
                    HierarchyId = "hierarchyId"
                }
            } },
            Rows = new [] { new DimensionFieldProperty {
                CategoricalDimensionField = new CategoricalDimensionFieldProperty {
                    Column = new ColumnIdentifierProperty {
                        ColumnName = "columnName",
                        DataSetIdentifier = "dataSetIdentifier"
                    },
                    FieldId = "fieldId",

                    // the properties below are optional
                    FormatConfiguration = new StringFormatConfigurationProperty {
                        NullValueFormatConfiguration = new NullValueFormatConfigurationProperty {
                            NullString = "nullString"
                        },
                        NumericFormatConfiguration = new NumericFormatConfigurationProperty {
                            CurrencyDisplayFormatConfiguration = new CurrencyDisplayFormatConfigurationProperty {
                                DecimalPlacesConfiguration = new DecimalPlacesConfigurationProperty {
                                    DecimalPlaces = 123
                                },
                                NegativeValueConfiguration = new NegativeValueConfigurationProperty {
                                    DisplayMode = "displayMode"
                                },
                                NullValueFormatConfiguration = new NullValueFormatConfigurationProperty {
                                    NullString = "nullString"
                                },
                                NumberScale = "numberScale",
                                Prefix = "prefix",
                                SeparatorConfiguration = new NumericSeparatorConfigurationProperty {
                                    DecimalSeparator = "decimalSeparator",
                                    ThousandsSeparator = new ThousandSeparatorOptionsProperty {
                                        Symbol = "symbol",
                                        Visibility = "visibility"
                                    }
                                },
                                Suffix = "suffix",
                                Symbol = "symbol"
                            },
                            NumberDisplayFormatConfiguration = new NumberDisplayFormatConfigurationProperty {
                                DecimalPlacesConfiguration = new DecimalPlacesConfigurationProperty {
                                    DecimalPlaces = 123
                                },
                                NegativeValueConfiguration = new NegativeValueConfigurationProperty {
                                    DisplayMode = "displayMode"
                                },
                                NullValueFormatConfiguration = new NullValueFormatConfigurationProperty {
                                    NullString = "nullString"
                                },
                                NumberScale = "numberScale",
                                Prefix = "prefix",
                                SeparatorConfiguration = new NumericSeparatorConfigurationProperty {
                                    DecimalSeparator = "decimalSeparator",
                                    ThousandsSeparator = new ThousandSeparatorOptionsProperty {
                                        Symbol = "symbol",
                                        Visibility = "visibility"
                                    }
                                },
                                Suffix = "suffix"
                            },
                            PercentageDisplayFormatConfiguration = new PercentageDisplayFormatConfigurationProperty {
                                DecimalPlacesConfiguration = new DecimalPlacesConfigurationProperty {
                                    DecimalPlaces = 123
                                },
                                NegativeValueConfiguration = new NegativeValueConfigurationProperty {
                                    DisplayMode = "displayMode"
                                },
                                NullValueFormatConfiguration = new NullValueFormatConfigurationProperty {
                                    NullString = "nullString"
                                },
                                Prefix = "prefix",
                                SeparatorConfiguration = new NumericSeparatorConfigurationProperty {
                                    DecimalSeparator = "decimalSeparator",
                                    ThousandsSeparator = new ThousandSeparatorOptionsProperty {
                                        Symbol = "symbol",
                                        Visibility = "visibility"
                                    }
                                },
                                Suffix = "suffix"
                            }
                        }
                    },
                    HierarchyId = "hierarchyId"
                },
                DateDimensionField = new DateDimensionFieldProperty {
                    Column = new ColumnIdentifierProperty {
                        ColumnName = "columnName",
                        DataSetIdentifier = "dataSetIdentifier"
                    },
                    FieldId = "fieldId",

                    // the properties below are optional
                    DateGranularity = "dateGranularity",
                    FormatConfiguration = new DateTimeFormatConfigurationProperty {
                        DateTimeFormat = "dateTimeFormat",
                        NullValueFormatConfiguration = new NullValueFormatConfigurationProperty {
                            NullString = "nullString"
                        },
                        NumericFormatConfiguration = new NumericFormatConfigurationProperty {
                            CurrencyDisplayFormatConfiguration = new CurrencyDisplayFormatConfigurationProperty {
                                DecimalPlacesConfiguration = new DecimalPlacesConfigurationProperty {
                                    DecimalPlaces = 123
                                },
                                NegativeValueConfiguration = new NegativeValueConfigurationProperty {
                                    DisplayMode = "displayMode"
                                },
                                NullValueFormatConfiguration = new NullValueFormatConfigurationProperty {
                                    NullString = "nullString"
                                },
                                NumberScale = "numberScale",
                                Prefix = "prefix",
                                SeparatorConfiguration = new NumericSeparatorConfigurationProperty {
                                    DecimalSeparator = "decimalSeparator",
                                    ThousandsSeparator = new ThousandSeparatorOptionsProperty {
                                        Symbol = "symbol",
                                        Visibility = "visibility"
                                    }
                                },
                                Suffix = "suffix",
                                Symbol = "symbol"
                            },
                            NumberDisplayFormatConfiguration = new NumberDisplayFormatConfigurationProperty {
                                DecimalPlacesConfiguration = new DecimalPlacesConfigurationProperty {
                                    DecimalPlaces = 123
                                },
                                NegativeValueConfiguration = new NegativeValueConfigurationProperty {
                                    DisplayMode = "displayMode"
                                },
                                NullValueFormatConfiguration = new NullValueFormatConfigurationProperty {
                                    NullString = "nullString"
                                },
                                NumberScale = "numberScale",
                                Prefix = "prefix",
                                SeparatorConfiguration = new NumericSeparatorConfigurationProperty {
                                    DecimalSeparator = "decimalSeparator",
                                    ThousandsSeparator = new ThousandSeparatorOptionsProperty {
                                        Symbol = "symbol",
                                        Visibility = "visibility"
                                    }
                                },
                                Suffix = "suffix"
                            },
                            PercentageDisplayFormatConfiguration = new PercentageDisplayFormatConfigurationProperty {
                                DecimalPlacesConfiguration = new DecimalPlacesConfigurationProperty {
                                    DecimalPlaces = 123
                                },
                                NegativeValueConfiguration = new NegativeValueConfigurationProperty {
                                    DisplayMode = "displayMode"
                                },
                                NullValueFormatConfiguration = new NullValueFormatConfigurationProperty {
                                    NullString = "nullString"
                                },
                                Prefix = "prefix",
                                SeparatorConfiguration = new NumericSeparatorConfigurationProperty {
                                    DecimalSeparator = "decimalSeparator",
                                    ThousandsSeparator = new ThousandSeparatorOptionsProperty {
                                        Symbol = "symbol",
                                        Visibility = "visibility"
                                    }
                                },
                                Suffix = "suffix"
                            }
                        }
                    },
                    HierarchyId = "hierarchyId"
                },
                NumericalDimensionField = new NumericalDimensionFieldProperty {
                    Column = new ColumnIdentifierProperty {
                        ColumnName = "columnName",
                        DataSetIdentifier = "dataSetIdentifier"
                    },
                    FieldId = "fieldId",

                    // the properties below are optional
                    FormatConfiguration = new NumberFormatConfigurationProperty {
                        FormatConfiguration = new NumericFormatConfigurationProperty {
                            CurrencyDisplayFormatConfiguration = new CurrencyDisplayFormatConfigurationProperty {
                                DecimalPlacesConfiguration = new DecimalPlacesConfigurationProperty {
                                    DecimalPlaces = 123
                                },
                                NegativeValueConfiguration = new NegativeValueConfigurationProperty {
                                    DisplayMode = "displayMode"
                                },
                                NullValueFormatConfiguration = new NullValueFormatConfigurationProperty {
                                    NullString = "nullString"
                                },
                                NumberScale = "numberScale",
                                Prefix = "prefix",
                                SeparatorConfiguration = new NumericSeparatorConfigurationProperty {
                                    DecimalSeparator = "decimalSeparator",
                                    ThousandsSeparator = new ThousandSeparatorOptionsProperty {
                                        Symbol = "symbol",
                                        Visibility = "visibility"
                                    }
                                },
                                Suffix = "suffix",
                                Symbol = "symbol"
                            },
                            NumberDisplayFormatConfiguration = new NumberDisplayFormatConfigurationProperty {
                                DecimalPlacesConfiguration = new DecimalPlacesConfigurationProperty {
                                    DecimalPlaces = 123
                                },
                                NegativeValueConfiguration = new NegativeValueConfigurationProperty {
                                    DisplayMode = "displayMode"
                                },
                                NullValueFormatConfiguration = new NullValueFormatConfigurationProperty {
                                    NullString = "nullString"
                                },
                                NumberScale = "numberScale",
                                Prefix = "prefix",
                                SeparatorConfiguration = new NumericSeparatorConfigurationProperty {
                                    DecimalSeparator = "decimalSeparator",
                                    ThousandsSeparator = new ThousandSeparatorOptionsProperty {
                                        Symbol = "symbol",
                                        Visibility = "visibility"
                                    }
                                },
                                Suffix = "suffix"
                            },
                            PercentageDisplayFormatConfiguration = new PercentageDisplayFormatConfigurationProperty {
                                DecimalPlacesConfiguration = new DecimalPlacesConfigurationProperty {
                                    DecimalPlaces = 123
                                },
                                NegativeValueConfiguration = new NegativeValueConfigurationProperty {
                                    DisplayMode = "displayMode"
                                },
                                NullValueFormatConfiguration = new NullValueFormatConfigurationProperty {
                                    NullString = "nullString"
                                },
                                Prefix = "prefix",
                                SeparatorConfiguration = new NumericSeparatorConfigurationProperty {
                                    DecimalSeparator = "decimalSeparator",
                                    ThousandsSeparator = new ThousandSeparatorOptionsProperty {
                                        Symbol = "symbol",
                                        Visibility = "visibility"
                                    }
                                },
                                Suffix = "suffix"
                            }
                        }
                    },
                    HierarchyId = "hierarchyId"
                }
            } },
            Values = new [] { new MeasureFieldProperty {
                CalculatedMeasureField = new CalculatedMeasureFieldProperty {
                    Expression = "expression",
                    FieldId = "fieldId"
                },
                CategoricalMeasureField = new CategoricalMeasureFieldProperty {
                    Column = new ColumnIdentifierProperty {
                        ColumnName = "columnName",
                        DataSetIdentifier = "dataSetIdentifier"
                    },
                    FieldId = "fieldId",

                    // the properties below are optional
                    AggregationFunction = "aggregationFunction",
                    FormatConfiguration = new StringFormatConfigurationProperty {
                        NullValueFormatConfiguration = new NullValueFormatConfigurationProperty {
                            NullString = "nullString"
                        },
                        NumericFormatConfiguration = new NumericFormatConfigurationProperty {
                            CurrencyDisplayFormatConfiguration = new CurrencyDisplayFormatConfigurationProperty {
                                DecimalPlacesConfiguration = new DecimalPlacesConfigurationProperty {
                                    DecimalPlaces = 123
                                },
                                NegativeValueConfiguration = new NegativeValueConfigurationProperty {
                                    DisplayMode = "displayMode"
                                },
                                NullValueFormatConfiguration = new NullValueFormatConfigurationProperty {
                                    NullString = "nullString"
                                },
                                NumberScale = "numberScale",
                                Prefix = "prefix",
                                SeparatorConfiguration = new NumericSeparatorConfigurationProperty {
                                    DecimalSeparator = "decimalSeparator",
                                    ThousandsSeparator = new ThousandSeparatorOptionsProperty {
                                        Symbol = "symbol",
                                        Visibility = "visibility"
                                    }
                                },
                                Suffix = "suffix",
                                Symbol = "symbol"
                            },
                            NumberDisplayFormatConfiguration = new NumberDisplayFormatConfigurationProperty {
                                DecimalPlacesConfiguration = new DecimalPlacesConfigurationProperty {
                                    DecimalPlaces = 123
                                },
                                NegativeValueConfiguration = new NegativeValueConfigurationProperty {
                                    DisplayMode = "displayMode"
                                },
                                NullValueFormatConfiguration = new NullValueFormatConfigurationProperty {
                                    NullString = "nullString"
                                },
                                NumberScale = "numberScale",
                                Prefix = "prefix",
                                SeparatorConfiguration = new NumericSeparatorConfigurationProperty {
                                    DecimalSeparator = "decimalSeparator",
                                    ThousandsSeparator = new ThousandSeparatorOptionsProperty {
                                        Symbol = "symbol",
                                        Visibility = "visibility"
                                    }
                                },
                                Suffix = "suffix"
                            },
                            PercentageDisplayFormatConfiguration = new PercentageDisplayFormatConfigurationProperty {
                                DecimalPlacesConfiguration = new DecimalPlacesConfigurationProperty {
                                    DecimalPlaces = 123
                                },
                                NegativeValueConfiguration = new NegativeValueConfigurationProperty {
                                    DisplayMode = "displayMode"
                                },
                                NullValueFormatConfiguration = new NullValueFormatConfigurationProperty {
                                    NullString = "nullString"
                                },
                                Prefix = "prefix",
                                SeparatorConfiguration = new NumericSeparatorConfigurationProperty {
                                    DecimalSeparator = "decimalSeparator",
                                    ThousandsSeparator = new ThousandSeparatorOptionsProperty {
                                        Symbol = "symbol",
                                        Visibility = "visibility"
                                    }
                                },
                                Suffix = "suffix"
                            }
                        }
                    }
                },
                DateMeasureField = new DateMeasureFieldProperty {
                    Column = new ColumnIdentifierProperty {
                        ColumnName = "columnName",
                        DataSetIdentifier = "dataSetIdentifier"
                    },
                    FieldId = "fieldId",

                    // the properties below are optional
                    AggregationFunction = "aggregationFunction",
                    FormatConfiguration = new DateTimeFormatConfigurationProperty {
                        DateTimeFormat = "dateTimeFormat",
                        NullValueFormatConfiguration = new NullValueFormatConfigurationProperty {
                            NullString = "nullString"
                        },
                        NumericFormatConfiguration = new NumericFormatConfigurationProperty {
                            CurrencyDisplayFormatConfiguration = new CurrencyDisplayFormatConfigurationProperty {
                                DecimalPlacesConfiguration = new DecimalPlacesConfigurationProperty {
                                    DecimalPlaces = 123
                                },
                                NegativeValueConfiguration = new NegativeValueConfigurationProperty {
                                    DisplayMode = "displayMode"
                                },
                                NullValueFormatConfiguration = new NullValueFormatConfigurationProperty {
                                    NullString = "nullString"
                                },
                                NumberScale = "numberScale",
                                Prefix = "prefix",
                                SeparatorConfiguration = new NumericSeparatorConfigurationProperty {
                                    DecimalSeparator = "decimalSeparator",
                                    ThousandsSeparator = new ThousandSeparatorOptionsProperty {
                                        Symbol = "symbol",
                                        Visibility = "visibility"
                                    }
                                },
                                Suffix = "suffix",
                                Symbol = "symbol"
                            },
                            NumberDisplayFormatConfiguration = new NumberDisplayFormatConfigurationProperty {
                                DecimalPlacesConfiguration = new DecimalPlacesConfigurationProperty {
                                    DecimalPlaces = 123
                                },
                                NegativeValueConfiguration = new NegativeValueConfigurationProperty {
                                    DisplayMode = "displayMode"
                                },
                                NullValueFormatConfiguration = new NullValueFormatConfigurationProperty {
                                    NullString = "nullString"
                                },
                                NumberScale = "numberScale",
                                Prefix = "prefix",
                                SeparatorConfiguration = new NumericSeparatorConfigurationProperty {
                                    DecimalSeparator = "decimalSeparator",
                                    ThousandsSeparator = new ThousandSeparatorOptionsProperty {
                                        Symbol = "symbol",
                                        Visibility = "visibility"
                                    }
                                },
                                Suffix = "suffix"
                            },
                            PercentageDisplayFormatConfiguration = new PercentageDisplayFormatConfigurationProperty {
                                DecimalPlacesConfiguration = new DecimalPlacesConfigurationProperty {
                                    DecimalPlaces = 123
                                },
                                NegativeValueConfiguration = new NegativeValueConfigurationProperty {
                                    DisplayMode = "displayMode"
                                },
                                NullValueFormatConfiguration = new NullValueFormatConfigurationProperty {
                                    NullString = "nullString"
                                },
                                Prefix = "prefix",
                                SeparatorConfiguration = new NumericSeparatorConfigurationProperty {
                                    DecimalSeparator = "decimalSeparator",
                                    ThousandsSeparator = new ThousandSeparatorOptionsProperty {
                                        Symbol = "symbol",
                                        Visibility = "visibility"
                                    }
                                },
                                Suffix = "suffix"
                            }
                        }
                    }
                },
                NumericalMeasureField = new NumericalMeasureFieldProperty {
                    Column = new ColumnIdentifierProperty {
                        ColumnName = "columnName",
                        DataSetIdentifier = "dataSetIdentifier"
                    },
                    FieldId = "fieldId",

                    // the properties below are optional
                    AggregationFunction = new NumericalAggregationFunctionProperty {
                        PercentileAggregation = new PercentileAggregationProperty {
                            PercentileValue = 123
                        },
                        SimpleNumericalAggregation = "simpleNumericalAggregation"
                    },
                    FormatConfiguration = new NumberFormatConfigurationProperty {
                        FormatConfiguration = new NumericFormatConfigurationProperty {
                            CurrencyDisplayFormatConfiguration = new CurrencyDisplayFormatConfigurationProperty {
                                DecimalPlacesConfiguration = new DecimalPlacesConfigurationProperty {
                                    DecimalPlaces = 123
                                },
                                NegativeValueConfiguration = new NegativeValueConfigurationProperty {
                                    DisplayMode = "displayMode"
                                },
                                NullValueFormatConfiguration = new NullValueFormatConfigurationProperty {
                                    NullString = "nullString"
                                },
                                NumberScale = "numberScale",
                                Prefix = "prefix",
                                SeparatorConfiguration = new NumericSeparatorConfigurationProperty {
                                    DecimalSeparator = "decimalSeparator",
                                    ThousandsSeparator = new ThousandSeparatorOptionsProperty {
                                        Symbol = "symbol",
                                        Visibility = "visibility"
                                    }
                                },
                                Suffix = "suffix",
                                Symbol = "symbol"
                            },
                            NumberDisplayFormatConfiguration = new NumberDisplayFormatConfigurationProperty {
                                DecimalPlacesConfiguration = new DecimalPlacesConfigurationProperty {
                                    DecimalPlaces = 123
                                },
                                NegativeValueConfiguration = new NegativeValueConfigurationProperty {
                                    DisplayMode = "displayMode"
                                },
                                NullValueFormatConfiguration = new NullValueFormatConfigurationProperty {
                                    NullString = "nullString"
                                },
                                NumberScale = "numberScale",
                                Prefix = "prefix",
                                SeparatorConfiguration = new NumericSeparatorConfigurationProperty {
                                    DecimalSeparator = "decimalSeparator",
                                    ThousandsSeparator = new ThousandSeparatorOptionsProperty {
                                        Symbol = "symbol",
                                        Visibility = "visibility"
                                    }
                                },
                                Suffix = "suffix"
                            },
                            PercentageDisplayFormatConfiguration = new PercentageDisplayFormatConfigurationProperty {
                                DecimalPlacesConfiguration = new DecimalPlacesConfigurationProperty {
                                    DecimalPlaces = 123
                                },
                                NegativeValueConfiguration = new NegativeValueConfigurationProperty {
                                    DisplayMode = "displayMode"
                                },
                                NullValueFormatConfiguration = new NullValueFormatConfigurationProperty {
                                    NullString = "nullString"
                                },
                                Prefix = "prefix",
                                SeparatorConfiguration = new NumericSeparatorConfigurationProperty {
                                    DecimalSeparator = "decimalSeparator",
                                    ThousandsSeparator = new ThousandSeparatorOptionsProperty {
                                        Symbol = "symbol",
                                        Visibility = "visibility"
                                    }
                                },
                                Suffix = "suffix"
                            }
                        }
                    }
                }
            } }
        }
    },
    PaginatedReportOptions = new PivotTablePaginatedReportOptionsProperty {
        OverflowColumnHeaderVisibility = "overflowColumnHeaderVisibility",
        VerticalOverflowVisibility = "verticalOverflowVisibility"
    },
    SortConfiguration = new PivotTableSortConfigurationProperty {
        FieldSortOptions = new [] { new PivotFieldSortOptionsProperty {
            FieldId = "fieldId",
            SortBy = new PivotTableSortByProperty {
                Column = new ColumnSortProperty {
                    Direction = "direction",
                    SortBy = new ColumnIdentifierProperty {
                        ColumnName = "columnName",
                        DataSetIdentifier = "dataSetIdentifier"
                    },

                    // the properties below are optional
                    AggregationFunction = new AggregationFunctionProperty {
                        CategoricalAggregationFunction = "categoricalAggregationFunction",
                        DateAggregationFunction = "dateAggregationFunction",
                        NumericalAggregationFunction = new NumericalAggregationFunctionProperty {
                            PercentileAggregation = new PercentileAggregationProperty {
                                PercentileValue = 123
                            },
                            SimpleNumericalAggregation = "simpleNumericalAggregation"
                        }
                    }
                },
                DataPath = new DataPathSortProperty {
                    Direction = "direction",
                    SortPaths = new [] { new DataPathValueProperty {
                        FieldId = "fieldId",
                        FieldValue = "fieldValue"
                    } }
                },
                Field = new FieldSortProperty {
                    Direction = "direction",
                    FieldId = "fieldId"
                }
            }
        } }
    },
    TableOptions = new PivotTableOptionsProperty {
        CellStyle = new TableCellStyleProperty {
            BackgroundColor = "backgroundColor",
            Border = new GlobalTableBorderOptionsProperty {
                SideSpecificBorder = new TableSideBorderOptionsProperty {
                    Bottom = new TableBorderOptionsProperty {
                        Color = "color",
                        Style = "style",
                        Thickness = 123
                    },
                    InnerHorizontal = new TableBorderOptionsProperty {
                        Color = "color",
                        Style = "style",
                        Thickness = 123
                    },
                    InnerVertical = new TableBorderOptionsProperty {
                        Color = "color",
                        Style = "style",
                        Thickness = 123
                    },
                    Left = new TableBorderOptionsProperty {
                        Color = "color",
                        Style = "style",
                        Thickness = 123
                    },
                    Right = new TableBorderOptionsProperty {
                        Color = "color",
                        Style = "style",
                        Thickness = 123
                    },
                    Top = new TableBorderOptionsProperty {
                        Color = "color",
                        Style = "style",
                        Thickness = 123
                    }
                },
                UniformBorder = new TableBorderOptionsProperty {
                    Color = "color",
                    Style = "style",
                    Thickness = 123
                }
            },
            FontConfiguration = new FontConfigurationProperty {
                FontColor = "fontColor",
                FontDecoration = "fontDecoration",
                FontSize = new FontSizeProperty {
                    Relative = "relative"
                },
                FontStyle = "fontStyle",
                FontWeight = new FontWeightProperty {
                    Name = "name"
                }
            },
            Height = 123,
            HorizontalTextAlignment = "horizontalTextAlignment",
            TextWrap = "textWrap",
            VerticalTextAlignment = "verticalTextAlignment",
            Visibility = "visibility"
        },
        ColumnHeaderStyle = new TableCellStyleProperty {
            BackgroundColor = "backgroundColor",
            Border = new GlobalTableBorderOptionsProperty {
                SideSpecificBorder = new TableSideBorderOptionsProperty {
                    Bottom = new TableBorderOptionsProperty {
                        Color = "color",
                        Style = "style",
                        Thickness = 123
                    },
                    InnerHorizontal = new TableBorderOptionsProperty {
                        Color = "color",
                        Style = "style",
                        Thickness = 123
                    },
                    InnerVertical = new TableBorderOptionsProperty {
                        Color = "color",
                        Style = "style",
                        Thickness = 123
                    },
                    Left = new TableBorderOptionsProperty {
                        Color = "color",
                        Style = "style",
                        Thickness = 123
                    },
                    Right = new TableBorderOptionsProperty {
                        Color = "color",
                        Style = "style",
                        Thickness = 123
                    },
                    Top = new TableBorderOptionsProperty {
                        Color = "color",
                        Style = "style",
                        Thickness = 123
                    }
                },
                UniformBorder = new TableBorderOptionsProperty {
                    Color = "color",
                    Style = "style",
                    Thickness = 123
                }
            },
            FontConfiguration = new FontConfigurationProperty {
                FontColor = "fontColor",
                FontDecoration = "fontDecoration",
                FontSize = new FontSizeProperty {
                    Relative = "relative"
                },
                FontStyle = "fontStyle",
                FontWeight = new FontWeightProperty {
                    Name = "name"
                }
            },
            Height = 123,
            HorizontalTextAlignment = "horizontalTextAlignment",
            TextWrap = "textWrap",
            VerticalTextAlignment = "verticalTextAlignment",
            Visibility = "visibility"
        },
        ColumnNamesVisibility = "columnNamesVisibility",
        MetricPlacement = "metricPlacement",
        RowAlternateColorOptions = new RowAlternateColorOptionsProperty {
            RowAlternateColors = new [] { "rowAlternateColors" },
            Status = "status"
        },
        RowFieldNamesStyle = new TableCellStyleProperty {
            BackgroundColor = "backgroundColor",
            Border = new GlobalTableBorderOptionsProperty {
                SideSpecificBorder = new TableSideBorderOptionsProperty {
                    Bottom = new TableBorderOptionsProperty {
                        Color = "color",
                        Style = "style",
                        Thickness = 123
                    },
                    InnerHorizontal = new TableBorderOptionsProperty {
                        Color = "color",
                        Style = "style",
                        Thickness = 123
                    },
                    InnerVertical = new TableBorderOptionsProperty {
                        Color = "color",
                        Style = "style",
                        Thickness = 123
                    },
                    Left = new TableBorderOptionsProperty {
                        Color = "color",
                        Style = "style",
                        Thickness = 123
                    },
                    Right = new TableBorderOptionsProperty {
                        Color = "color",
                        Style = "style",
                        Thickness = 123
                    },
                    Top = new TableBorderOptionsProperty {
                        Color = "color",
                        Style = "style",
                        Thickness = 123
                    }
                },
                UniformBorder = new TableBorderOptionsProperty {
                    Color = "color",
                    Style = "style",
                    Thickness = 123
                }
            },
            FontConfiguration = new FontConfigurationProperty {
                FontColor = "fontColor",
                FontDecoration = "fontDecoration",
                FontSize = new FontSizeProperty {
                    Relative = "relative"
                },
                FontStyle = "fontStyle",
                FontWeight = new FontWeightProperty {
                    Name = "name"
                }
            },
            Height = 123,
            HorizontalTextAlignment = "horizontalTextAlignment",
            TextWrap = "textWrap",
            VerticalTextAlignment = "verticalTextAlignment",
            Visibility = "visibility"
        },
        RowHeaderStyle = new TableCellStyleProperty {
            BackgroundColor = "backgroundColor",
            Border = new GlobalTableBorderOptionsProperty {
                SideSpecificBorder = new TableSideBorderOptionsProperty {
                    Bottom = new TableBorderOptionsProperty {
                        Color = "color",
                        Style = "style",
                        Thickness = 123
                    },
                    InnerHorizontal = new TableBorderOptionsProperty {
                        Color = "color",
                        Style = "style",
                        Thickness = 123
                    },
                    InnerVertical = new TableBorderOptionsProperty {
                        Color = "color",
                        Style = "style",
                        Thickness = 123
                    },
                    Left = new TableBorderOptionsProperty {
                        Color = "color",
                        Style = "style",
                        Thickness = 123
                    },
                    Right = new TableBorderOptionsProperty {
                        Color = "color",
                        Style = "style",
                        Thickness = 123
                    },
                    Top = new TableBorderOptionsProperty {
                        Color = "color",
                        Style = "style",
                        Thickness = 123
                    }
                },
                UniformBorder = new TableBorderOptionsProperty {
                    Color = "color",
                    Style = "style",
                    Thickness = 123
                }
            },
            FontConfiguration = new FontConfigurationProperty {
                FontColor = "fontColor",
                FontDecoration = "fontDecoration",
                FontSize = new FontSizeProperty {
                    Relative = "relative"
                },
                FontStyle = "fontStyle",
                FontWeight = new FontWeightProperty {
                    Name = "name"
                }
            },
            Height = 123,
            HorizontalTextAlignment = "horizontalTextAlignment",
            TextWrap = "textWrap",
            VerticalTextAlignment = "verticalTextAlignment",
            Visibility = "visibility"
        },
        SingleMetricVisibility = "singleMetricVisibility",
        ToggleButtonsVisibility = "toggleButtonsVisibility"
    },
    TotalOptions = new PivotTableTotalOptionsProperty {
        ColumnSubtotalOptions = new SubtotalOptionsProperty {
            CustomLabel = "customLabel",
            FieldLevel = "fieldLevel",
            FieldLevelOptions = new [] { new PivotTableFieldSubtotalOptionsProperty {
                FieldId = "fieldId"
            } },
            MetricHeaderCellStyle = new TableCellStyleProperty {
                BackgroundColor = "backgroundColor",
                Border = new GlobalTableBorderOptionsProperty {
                    SideSpecificBorder = new TableSideBorderOptionsProperty {
                        Bottom = new TableBorderOptionsProperty {
                            Color = "color",
                            Style = "style",
                            Thickness = 123
                        },
                        InnerHorizontal = new TableBorderOptionsProperty {
                            Color = "color",
                            Style = "style",
                            Thickness = 123
                        },
                        InnerVertical = new TableBorderOptionsProperty {
                            Color = "color",
                            Style = "style",
                            Thickness = 123
                        },
                        Left = new TableBorderOptionsProperty {
                            Color = "color",
                            Style = "style",
                            Thickness = 123
                        },
                        Right = new TableBorderOptionsProperty {
                            Color = "color",
                            Style = "style",
                            Thickness = 123
                        },
                        Top = new TableBorderOptionsProperty {
                            Color = "color",
                            Style = "style",
                            Thickness = 123
                        }
                    },
                    UniformBorder = new TableBorderOptionsProperty {
                        Color = "color",
                        Style = "style",
                        Thickness = 123
                    }
                },
                FontConfiguration = new FontConfigurationProperty {
                    FontColor = "fontColor",
                    FontDecoration = "fontDecoration",
                    FontSize = new FontSizeProperty {
                        Relative = "relative"
                    },
                    FontStyle = "fontStyle",
                    FontWeight = new FontWeightProperty {
                        Name = "name"
                    }
                },
                Height = 123,
                HorizontalTextAlignment = "horizontalTextAlignment",
                TextWrap = "textWrap",
                VerticalTextAlignment = "verticalTextAlignment",
                Visibility = "visibility"
            },
            TotalCellStyle = new TableCellStyleProperty {
                BackgroundColor = "backgroundColor",
                Border = new GlobalTableBorderOptionsProperty {
                    SideSpecificBorder = new TableSideBorderOptionsProperty {
                        Bottom = new TableBorderOptionsProperty {
                            Color = "color",
                            Style = "style",
                            Thickness = 123
                        },
                        InnerHorizontal = new TableBorderOptionsProperty {
                            Color = "color",
                            Style = "style",
                            Thickness = 123
                        },
                        InnerVertical = new TableBorderOptionsProperty {
                            Color = "color",
                            Style = "style",
                            Thickness = 123
                        },
                        Left = new TableBorderOptionsProperty {
                            Color = "color",
                            Style = "style",
                            Thickness = 123
                        },
                        Right = new TableBorderOptionsProperty {
                            Color = "color",
                            Style = "style",
                            Thickness = 123
                        },
                        Top = new TableBorderOptionsProperty {
                            Color = "color",
                            Style = "style",
                            Thickness = 123
                        }
                    },
                    UniformBorder = new TableBorderOptionsProperty {
                        Color = "color",
                        Style = "style",
                        Thickness = 123
                    }
                },
                FontConfiguration = new FontConfigurationProperty {
                    FontColor = "fontColor",
                    FontDecoration = "fontDecoration",
                    FontSize = new FontSizeProperty {
                        Relative = "relative"
                    },
                    FontStyle = "fontStyle",
                    FontWeight = new FontWeightProperty {
                        Name = "name"
                    }
                },
                Height = 123,
                HorizontalTextAlignment = "horizontalTextAlignment",
                TextWrap = "textWrap",
                VerticalTextAlignment = "verticalTextAlignment",
                Visibility = "visibility"
            },
            TotalsVisibility = "totalsVisibility",
            ValueCellStyle = new TableCellStyleProperty {
                BackgroundColor = "backgroundColor",
                Border = new GlobalTableBorderOptionsProperty {
                    SideSpecificBorder = new TableSideBorderOptionsProperty {
                        Bottom = new TableBorderOptionsProperty {
                            Color = "color",
                            Style = "style",
                            Thickness = 123
                        },
                        InnerHorizontal = new TableBorderOptionsProperty {
                            Color = "color",
                            Style = "style",
                            Thickness = 123
                        },
                        InnerVertical = new TableBorderOptionsProperty {
                            Color = "color",
                            Style = "style",
                            Thickness = 123
                        },
                        Left = new TableBorderOptionsProperty {
                            Color = "color",
                            Style = "style",
                            Thickness = 123
                        },
                        Right = new TableBorderOptionsProperty {
                            Color = "color",
                            Style = "style",
                            Thickness = 123
                        },
                        Top = new TableBorderOptionsProperty {
                            Color = "color",
                            Style = "style",
                            Thickness = 123
                        }
                    },
                    UniformBorder = new TableBorderOptionsProperty {
                        Color = "color",
                        Style = "style",
                        Thickness = 123
                    }
                },
                FontConfiguration = new FontConfigurationProperty {
                    FontColor = "fontColor",
                    FontDecoration = "fontDecoration",
                    FontSize = new FontSizeProperty {
                        Relative = "relative"
                    },
                    FontStyle = "fontStyle",
                    FontWeight = new FontWeightProperty {
                        Name = "name"
                    }
                },
                Height = 123,
                HorizontalTextAlignment = "horizontalTextAlignment",
                TextWrap = "textWrap",
                VerticalTextAlignment = "verticalTextAlignment",
                Visibility = "visibility"
            }
        },
        ColumnTotalOptions = new PivotTotalOptionsProperty {
            CustomLabel = "customLabel",
            MetricHeaderCellStyle = new TableCellStyleProperty {
                BackgroundColor = "backgroundColor",
                Border = new GlobalTableBorderOptionsProperty {
                    SideSpecificBorder = new TableSideBorderOptionsProperty {
                        Bottom = new TableBorderOptionsProperty {
                            Color = "color",
                            Style = "style",
                            Thickness = 123
                        },
                        InnerHorizontal = new TableBorderOptionsProperty {
                            Color = "color",
                            Style = "style",
                            Thickness = 123
                        },
                        InnerVertical = new TableBorderOptionsProperty {
                            Color = "color",
                            Style = "style",
                            Thickness = 123
                        },
                        Left = new TableBorderOptionsProperty {
                            Color = "color",
                            Style = "style",
                            Thickness = 123
                        },
                        Right = new TableBorderOptionsProperty {
                            Color = "color",
                            Style = "style",
                            Thickness = 123
                        },
                        Top = new TableBorderOptionsProperty {
                            Color = "color",
                            Style = "style",
                            Thickness = 123
                        }
                    },
                    UniformBorder = new TableBorderOptionsProperty {
                        Color = "color",
                        Style = "style",
                        Thickness = 123
                    }
                },
                FontConfiguration = new FontConfigurationProperty {
                    FontColor = "fontColor",
                    FontDecoration = "fontDecoration",
                    FontSize = new FontSizeProperty {
                        Relative = "relative"
                    },
                    FontStyle = "fontStyle",
                    FontWeight = new FontWeightProperty {
                        Name = "name"
                    }
                },
                Height = 123,
                HorizontalTextAlignment = "horizontalTextAlignment",
                TextWrap = "textWrap",
                VerticalTextAlignment = "verticalTextAlignment",
                Visibility = "visibility"
            },
            Placement = "placement",
            ScrollStatus = "scrollStatus",
            TotalCellStyle = new TableCellStyleProperty {
                BackgroundColor = "backgroundColor",
                Border = new GlobalTableBorderOptionsProperty {
                    SideSpecificBorder = new TableSideBorderOptionsProperty {
                        Bottom = new TableBorderOptionsProperty {
                            Color = "color",
                            Style = "style",
                            Thickness = 123
                        },
                        InnerHorizontal = new TableBorderOptionsProperty {
                            Color = "color",
                            Style = "style",
                            Thickness = 123
                        },
                        InnerVertical = new TableBorderOptionsProperty {
                            Color = "color",
                            Style = "style",
                            Thickness = 123
                        },
                        Left = new TableBorderOptionsProperty {
                            Color = "color",
                            Style = "style",
                            Thickness = 123
                        },
                        Right = new TableBorderOptionsProperty {
                            Color = "color",
                            Style = "style",
                            Thickness = 123
                        },
                        Top = new TableBorderOptionsProperty {
                            Color = "color",
                            Style = "style",
                            Thickness = 123
                        }
                    },
                    UniformBorder = new TableBorderOptionsProperty {
                        Color = "color",
                        Style = "style",
                        Thickness = 123
                    }
                },
                FontConfiguration = new FontConfigurationProperty {
                    FontColor = "fontColor",
                    FontDecoration = "fontDecoration",
                    FontSize = new FontSizeProperty {
                        Relative = "relative"
                    },
                    FontStyle = "fontStyle",
                    FontWeight = new FontWeightProperty {
                        Name = "name"
                    }
                },
                Height = 123,
                HorizontalTextAlignment = "horizontalTextAlignment",
                TextWrap = "textWrap",
                VerticalTextAlignment = "verticalTextAlignment",
                Visibility = "visibility"
            },
            TotalsVisibility = "totalsVisibility",
            ValueCellStyle = new TableCellStyleProperty {
                BackgroundColor = "backgroundColor",
                Border = new GlobalTableBorderOptionsProperty {
                    SideSpecificBorder = new TableSideBorderOptionsProperty {
                        Bottom = new TableBorderOptionsProperty {
                            Color = "color",
                            Style = "style",
                            Thickness = 123
                        },
                        InnerHorizontal = new TableBorderOptionsProperty {
                            Color = "color",
                            Style = "style",
                            Thickness = 123
                        },
                        InnerVertical = new TableBorderOptionsProperty {
                            Color = "color",
                            Style = "style",
                            Thickness = 123
                        },
                        Left = new TableBorderOptionsProperty {
                            Color = "color",
                            Style = "style",
                            Thickness = 123
                        },
                        Right = new TableBorderOptionsProperty {
                            Color = "color",
                            Style = "style",
                            Thickness = 123
                        },
                        Top = new TableBorderOptionsProperty {
                            Color = "color",
                            Style = "style",
                            Thickness = 123
                        }
                    },
                    UniformBorder = new TableBorderOptionsProperty {
                        Color = "color",
                        Style = "style",
                        Thickness = 123
                    }
                },
                FontConfiguration = new FontConfigurationProperty {
                    FontColor = "fontColor",
                    FontDecoration = "fontDecoration",
                    FontSize = new FontSizeProperty {
                        Relative = "relative"
                    },
                    FontStyle = "fontStyle",
                    FontWeight = new FontWeightProperty {
                        Name = "name"
                    }
                },
                Height = 123,
                HorizontalTextAlignment = "horizontalTextAlignment",
                TextWrap = "textWrap",
                VerticalTextAlignment = "verticalTextAlignment",
                Visibility = "visibility"
            }
        },
        RowSubtotalOptions = new SubtotalOptionsProperty {
            CustomLabel = "customLabel",
            FieldLevel = "fieldLevel",
            FieldLevelOptions = new [] { new PivotTableFieldSubtotalOptionsProperty {
                FieldId = "fieldId"
            } },
            MetricHeaderCellStyle = new TableCellStyleProperty {
                BackgroundColor = "backgroundColor",
                Border = new GlobalTableBorderOptionsProperty {
                    SideSpecificBorder = new TableSideBorderOptionsProperty {
                        Bottom = new TableBorderOptionsProperty {
                            Color = "color",
                            Style = "style",
                            Thickness = 123
                        },
                        InnerHorizontal = new TableBorderOptionsProperty {
                            Color = "color",
                            Style = "style",
                            Thickness = 123
                        },
                        InnerVertical = new TableBorderOptionsProperty {
                            Color = "color",
                            Style = "style",
                            Thickness = 123
                        },
                        Left = new TableBorderOptionsProperty {
                            Color = "color",
                            Style = "style",
                            Thickness = 123
                        },
                        Right = new TableBorderOptionsProperty {
                            Color = "color",
                            Style = "style",
                            Thickness = 123
                        },
                        Top = new TableBorderOptionsProperty {
                            Color = "color",
                            Style = "style",
                            Thickness = 123
                        }
                    },
                    UniformBorder = new TableBorderOptionsProperty {
                        Color = "color",
                        Style = "style",
                        Thickness = 123
                    }
                },
                FontConfiguration = new FontConfigurationProperty {
                    FontColor = "fontColor",
                    FontDecoration = "fontDecoration",
                    FontSize = new FontSizeProperty {
                        Relative = "relative"
                    },
                    FontStyle = "fontStyle",
                    FontWeight = new FontWeightProperty {
                        Name = "name"
                    }
                },
                Height = 123,
                HorizontalTextAlignment = "horizontalTextAlignment",
                TextWrap = "textWrap",
                VerticalTextAlignment = "verticalTextAlignment",
                Visibility = "visibility"
            },
            TotalCellStyle = new TableCellStyleProperty {
                BackgroundColor = "backgroundColor",
                Border = new GlobalTableBorderOptionsProperty {
                    SideSpecificBorder = new TableSideBorderOptionsProperty {
                        Bottom = new TableBorderOptionsProperty {
                            Color = "color",
                            Style = "style",
                            Thickness = 123
                        },
                        InnerHorizontal = new TableBorderOptionsProperty {
                            Color = "color",
                            Style = "style",
                            Thickness = 123
                        },
                        InnerVertical = new TableBorderOptionsProperty {
                            Color = "color",
                            Style = "style",
                            Thickness = 123
                        },
                        Left = new TableBorderOptionsProperty {
                            Color = "color",
                            Style = "style",
                            Thickness = 123
                        },
                        Right = new TableBorderOptionsProperty {
                            Color = "color",
                            Style = "style",
                            Thickness = 123
                        },
                        Top = new TableBorderOptionsProperty {
                            Color = "color",
                            Style = "style",
                            Thickness = 123
                        }
                    },
                    UniformBorder = new TableBorderOptionsProperty {
                        Color = "color",
                        Style = "style",
                        Thickness = 123
                    }
                },
                FontConfiguration = new FontConfigurationProperty {
                    FontColor = "fontColor",
                    FontDecoration = "fontDecoration",
                    FontSize = new FontSizeProperty {
                        Relative = "relative"
                    },
                    FontStyle = "fontStyle",
                    FontWeight = new FontWeightProperty {
                        Name = "name"
                    }
                },
                Height = 123,
                HorizontalTextAlignment = "horizontalTextAlignment",
                TextWrap = "textWrap",
                VerticalTextAlignment = "verticalTextAlignment",
                Visibility = "visibility"
            },
            TotalsVisibility = "totalsVisibility",
            ValueCellStyle = new TableCellStyleProperty {
                BackgroundColor = "backgroundColor",
                Border = new GlobalTableBorderOptionsProperty {
                    SideSpecificBorder = new TableSideBorderOptionsProperty {
                        Bottom = new TableBorderOptionsProperty {
                            Color = "color",
                            Style = "style",
                            Thickness = 123
                        },
                        InnerHorizontal = new TableBorderOptionsProperty {
                            Color = "color",
                            Style = "style",
                            Thickness = 123
                        },
                        InnerVertical = new TableBorderOptionsProperty {
                            Color = "color",
                            Style = "style",
                            Thickness = 123
                        },
                        Left = new TableBorderOptionsProperty {
                            Color = "color",
                            Style = "style",
                            Thickness = 123
                        },
                        Right = new TableBorderOptionsProperty {
                            Color = "color",
                            Style = "style",
                            Thickness = 123
                        },
                        Top = new TableBorderOptionsProperty {
                            Color = "color",
                            Style = "style",
                            Thickness = 123
                        }
                    },
                    UniformBorder = new TableBorderOptionsProperty {
                        Color = "color",
                        Style = "style",
                        Thickness = 123
                    }
                },
                FontConfiguration = new FontConfigurationProperty {
                    FontColor = "fontColor",
                    FontDecoration = "fontDecoration",
                    FontSize = new FontSizeProperty {
                        Relative = "relative"
                    },
                    FontStyle = "fontStyle",
                    FontWeight = new FontWeightProperty {
                        Name = "name"
                    }
                },
                Height = 123,
                HorizontalTextAlignment = "horizontalTextAlignment",
                TextWrap = "textWrap",
                VerticalTextAlignment = "verticalTextAlignment",
                Visibility = "visibility"
            }
        },
        RowTotalOptions = new PivotTotalOptionsProperty {
            CustomLabel = "customLabel",
            MetricHeaderCellStyle = new TableCellStyleProperty {
                BackgroundColor = "backgroundColor",
                Border = new GlobalTableBorderOptionsProperty {
                    SideSpecificBorder = new TableSideBorderOptionsProperty {
                        Bottom = new TableBorderOptionsProperty {
                            Color = "color",
                            Style = "style",
                            Thickness = 123
                        },
                        InnerHorizontal = new TableBorderOptionsProperty {
                            Color = "color",
                            Style = "style",
                            Thickness = 123
                        },
                        InnerVertical = new TableBorderOptionsProperty {
                            Color = "color",
                            Style = "style",
                            Thickness = 123
                        },
                        Left = new TableBorderOptionsProperty {
                            Color = "color",
                            Style = "style",
                            Thickness = 123
                        },
                        Right = new TableBorderOptionsProperty {
                            Color = "color",
                            Style = "style",
                            Thickness = 123
                        },
                        Top = new TableBorderOptionsProperty {
                            Color = "color",
                            Style = "style",
                            Thickness = 123
                        }
                    },
                    UniformBorder = new TableBorderOptionsProperty {
                        Color = "color",
                        Style = "style",
                        Thickness = 123
                    }
                },
                FontConfiguration = new FontConfigurationProperty {
                    FontColor = "fontColor",
                    FontDecoration = "fontDecoration",
                    FontSize = new FontSizeProperty {
                        Relative = "relative"
                    },
                    FontStyle = "fontStyle",
                    FontWeight = new FontWeightProperty {
                        Name = "name"
                    }
                },
                Height = 123,
                HorizontalTextAlignment = "horizontalTextAlignment",
                TextWrap = "textWrap",
                VerticalTextAlignment = "verticalTextAlignment",
                Visibility = "visibility"
            },
            Placement = "placement",
            ScrollStatus = "scrollStatus",
            TotalCellStyle = new TableCellStyleProperty {
                BackgroundColor = "backgroundColor",
                Border = new GlobalTableBorderOptionsProperty {
                    SideSpecificBorder = new TableSideBorderOptionsProperty {
                        Bottom = new TableBorderOptionsProperty {
                            Color = "color",
                            Style = "style",
                            Thickness = 123
                        },
                        InnerHorizontal = new TableBorderOptionsProperty {
                            Color = "color",
                            Style = "style",
                            Thickness = 123
                        },
                        InnerVertical = new TableBorderOptionsProperty {
                            Color = "color",
                            Style = "style",
                            Thickness = 123
                        },
                        Left = new TableBorderOptionsProperty {
                            Color = "color",
                            Style = "style",
                            Thickness = 123
                        },
                        Right = new TableBorderOptionsProperty {
                            Color = "color",
                            Style = "style",
                            Thickness = 123
                        },
                        Top = new TableBorderOptionsProperty {
                            Color = "color",
                            Style = "style",
                            Thickness = 123
                        }
                    },
                    UniformBorder = new TableBorderOptionsProperty {
                        Color = "color",
                        Style = "style",
                        Thickness = 123
                    }
                },
                FontConfiguration = new FontConfigurationProperty {
                    FontColor = "fontColor",
                    FontDecoration = "fontDecoration",
                    FontSize = new FontSizeProperty {
                        Relative = "relative"
                    },
                    FontStyle = "fontStyle",
                    FontWeight = new FontWeightProperty {
                        Name = "name"
                    }
                },
                Height = 123,
                HorizontalTextAlignment = "horizontalTextAlignment",
                TextWrap = "textWrap",
                VerticalTextAlignment = "verticalTextAlignment",
                Visibility = "visibility"
            },
            TotalsVisibility = "totalsVisibility",
            ValueCellStyle = new TableCellStyleProperty {
                BackgroundColor = "backgroundColor",
                Border = new GlobalTableBorderOptionsProperty {
                    SideSpecificBorder = new TableSideBorderOptionsProperty {
                        Bottom = new TableBorderOptionsProperty {
                            Color = "color",
                            Style = "style",
                            Thickness = 123
                        },
                        InnerHorizontal = new TableBorderOptionsProperty {
                            Color = "color",
                            Style = "style",
                            Thickness = 123
                        },
                        InnerVertical = new TableBorderOptionsProperty {
                            Color = "color",
                            Style = "style",
                            Thickness = 123
                        },
                        Left = new TableBorderOptionsProperty {
                            Color = "color",
                            Style = "style",
                            Thickness = 123
                        },
                        Right = new TableBorderOptionsProperty {
                            Color = "color",
                            Style = "style",
                            Thickness = 123
                        },
                        Top = new TableBorderOptionsProperty {
                            Color = "color",
                            Style = "style",
                            Thickness = 123
                        }
                    },
                    UniformBorder = new TableBorderOptionsProperty {
                        Color = "color",
                        Style = "style",
                        Thickness = 123
                    }
                },
                FontConfiguration = new FontConfigurationProperty {
                    FontColor = "fontColor",
                    FontDecoration = "fontDecoration",
                    FontSize = new FontSizeProperty {
                        Relative = "relative"
                    },
                    FontStyle = "fontStyle",
                    FontWeight = new FontWeightProperty {
                        Name = "name"
                    }
                },
                Height = 123,
                HorizontalTextAlignment = "horizontalTextAlignment",
                TextWrap = "textWrap",
                VerticalTextAlignment = "verticalTextAlignment",
                Visibility = "visibility"
            }
        }
    }
};

Synopsis

Constructors

PivotTableConfigurationProperty()

Properties

FieldOptions

The field options for a pivot table visual.

FieldWells

The field wells of the visual.

PaginatedReportOptions

The paginated report options for a pivot table visual.

SortConfiguration

The sort configuration for a PivotTableVisual .

TableOptions

The table options for a pivot table visual.

TotalOptions

The total options for a pivot table visual.

Constructors

PivotTableConfigurationProperty()

public PivotTableConfigurationProperty()

Properties

FieldOptions

The field options for a pivot table visual.

public object FieldOptions { get; set; }
Property Value

System.Object

Remarks

Link: http://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-properties-quicksight-analysis-pivottableconfiguration.html#cfn-quicksight-analysis-pivottableconfiguration-fieldoptions

FieldWells

The field wells of the visual.

public object FieldWells { get; set; }
Property Value

System.Object

Remarks

Link: http://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-properties-quicksight-analysis-pivottableconfiguration.html#cfn-quicksight-analysis-pivottableconfiguration-fieldwells

PaginatedReportOptions

The paginated report options for a pivot table visual.

public object PaginatedReportOptions { get; set; }
Property Value

System.Object

Remarks

Link: http://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-properties-quicksight-analysis-pivottableconfiguration.html#cfn-quicksight-analysis-pivottableconfiguration-paginatedreportoptions

SortConfiguration

The sort configuration for a PivotTableVisual .

public object SortConfiguration { get; set; }
Property Value

System.Object

Remarks

Link: http://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-properties-quicksight-analysis-pivottableconfiguration.html#cfn-quicksight-analysis-pivottableconfiguration-sortconfiguration

TableOptions

The table options for a pivot table visual.

public object TableOptions { get; set; }
Property Value

System.Object

Remarks

Link: http://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-properties-quicksight-analysis-pivottableconfiguration.html#cfn-quicksight-analysis-pivottableconfiguration-tableoptions

TotalOptions

The total options for a pivot table visual.

public object TotalOptions { get; set; }
Property Value

System.Object

Remarks

Link: http://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-properties-quicksight-analysis-pivottableconfiguration.html#cfn-quicksight-analysis-pivottableconfiguration-totaloptions

Implements

CfnAnalysis.IPivotTableConfigurationProperty
Back to top Generated by DocFX