Class CfnDashboard.PivotTableVisualProperty
A pivot table.
Inheritance
Implements
Namespace: Amazon.CDK.AWS.QuickSight
Assembly: Amazon.CDK.AWS.QuickSight.dll
Syntax (csharp)
public class PivotTableVisualProperty : Object, CfnDashboard.IPivotTableVisualProperty
Syntax (vb)
Public Class PivotTableVisualProperty
Inherits Object
Implements CfnDashboard.IPivotTableVisualProperty
Remarks
For more information, see Using pivot tables in the Amazon QuickSight User Guide .
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 pivotTableVisualProperty = new PivotTableVisualProperty {
VisualId = "visualId",
// the properties below are optional
Actions = new [] { new VisualCustomActionProperty {
ActionOperations = new [] { new VisualCustomActionOperationProperty {
FilterOperation = new CustomActionFilterOperationProperty {
SelectedFieldsConfiguration = new FilterOperationSelectedFieldsConfigurationProperty {
SelectedFieldOptions = "selectedFieldOptions",
SelectedFields = new [] { "selectedFields" }
},
TargetVisualsConfiguration = new FilterOperationTargetVisualsConfigurationProperty {
SameSheetTargetVisualConfiguration = new SameSheetTargetVisualConfigurationProperty {
TargetVisualOptions = "targetVisualOptions",
TargetVisuals = new [] { "targetVisuals" }
}
}
},
NavigationOperation = new CustomActionNavigationOperationProperty {
LocalNavigationConfiguration = new LocalNavigationConfigurationProperty {
TargetSheetId = "targetSheetId"
}
},
SetParametersOperation = new CustomActionSetParametersOperationProperty {
ParameterValueConfigurations = new [] { new SetParameterValueConfigurationProperty {
DestinationParameterName = "destinationParameterName",
Value = new DestinationParameterValueConfigurationProperty {
CustomValuesConfiguration = new CustomValuesConfigurationProperty {
CustomValues = new CustomParameterValuesProperty {
DateTimeValues = new [] { "dateTimeValues" },
DecimalValues = new [] { 123 },
IntegerValues = new [] { 123 },
StringValues = new [] { "stringValues" }
},
// the properties below are optional
IncludeNullValue = false
},
SelectAllValueOptions = "selectAllValueOptions",
SourceField = "sourceField",
SourceParameterName = "sourceParameterName"
}
} }
},
UrlOperation = new CustomActionURLOperationProperty {
UrlTarget = "urlTarget",
UrlTemplate = "urlTemplate"
}
} },
CustomActionId = "customActionId",
Name = "name",
Trigger = "trigger",
// the properties below are optional
Status = "status"
} },
ChartConfiguration = 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"
}
}
}
},
ConditionalFormatting = new PivotTableConditionalFormattingProperty {
ConditionalFormattingOptions = new [] { new PivotTableConditionalFormattingOptionProperty {
Cell = new PivotTableCellConditionalFormattingProperty {
FieldId = "fieldId",
// the properties below are optional
Scope = new PivotTableConditionalFormattingScopeProperty {
Role = "role"
},
TextFormat = new TextConditionalFormatProperty {
BackgroundColor = new ConditionalFormattingColorProperty {
Gradient = new ConditionalFormattingGradientColorProperty {
Color = new GradientColorProperty {
Stops = new [] { new GradientStopProperty {
GradientOffset = 123,
// the properties below are optional
Color = "color",
DataValue = 123
} }
},
Expression = "expression"
},
Solid = new ConditionalFormattingSolidColorProperty {
Expression = "expression",
// the properties below are optional
Color = "color"
}
},
Icon = new ConditionalFormattingIconProperty {
CustomCondition = new ConditionalFormattingCustomIconConditionProperty {
Expression = "expression",
IconOptions = new ConditionalFormattingCustomIconOptionsProperty {
Icon = "icon",
UnicodeIcon = "unicodeIcon"
},
// the properties below are optional
Color = "color",
DisplayConfiguration = new ConditionalFormattingIconDisplayConfigurationProperty {
IconDisplayOption = "iconDisplayOption"
}
},
IconSet = new ConditionalFormattingIconSetProperty {
Expression = "expression",
// the properties below are optional
IconSetType = "iconSetType"
}
},
TextColor = new ConditionalFormattingColorProperty {
Gradient = new ConditionalFormattingGradientColorProperty {
Color = new GradientColorProperty {
Stops = new [] { new GradientStopProperty {
GradientOffset = 123,
// the properties below are optional
Color = "color",
DataValue = 123
} }
},
Expression = "expression"
},
Solid = new ConditionalFormattingSolidColorProperty {
Expression = "expression",
// the properties below are optional
Color = "color"
}
}
}
}
} }
},
Subtitle = new VisualSubtitleLabelOptionsProperty {
FormatText = new LongFormatTextProperty {
PlainText = "plainText",
RichText = "richText"
},
Visibility = "visibility"
},
Title = new VisualTitleLabelOptionsProperty {
FormatText = new ShortFormatTextProperty {
PlainText = "plainText",
RichText = "richText"
},
Visibility = "visibility"
}
};
Synopsis
Constructors
PivotTableVisualProperty() |
Properties
Actions | The list of custom actions that are configured for a visual. |
ChartConfiguration | The configuration settings of the visual. |
ConditionalFormatting | The conditional formatting for a |
Subtitle | The subtitle that is displayed on the visual. |
Title | The title that is displayed on the visual. |
VisualId | The unique identifier of a visual. |
Constructors
PivotTableVisualProperty()
public PivotTableVisualProperty()
Properties
Actions
The list of custom actions that are configured for a visual.
public object Actions { get; set; }
Property Value
System.Object
Remarks
ChartConfiguration
The configuration settings of the visual.
public object ChartConfiguration { get; set; }
Property Value
System.Object
Remarks
ConditionalFormatting
The conditional formatting for a PivotTableVisual
.
public object ConditionalFormatting { get; set; }
Property Value
System.Object
Remarks
Subtitle
The subtitle that is displayed on the visual.
public object Subtitle { get; set; }
Property Value
System.Object
Remarks
Title
The title that is displayed on the visual.
public object Title { get; set; }
Property Value
System.Object
Remarks
VisualId
The unique identifier of a visual.
public string VisualId { get; set; }
Property Value
System.String
Remarks
This identifier must be unique within the context of a dashboard, template, or analysis. Two dashboards, analyses, or templates can have visuals with the same identifiers..