| ChartSelectionMode
Defines the pivot chart selection mode. They are
|
| ChartSeriesType
Defines the pivot chart types.
The available chart types are:
|
| ChartSettingsBorderChartSettings
|
| ChartSettingsPrimaryYAxisChartSettings
|
| ChartSettingsSubTitleStyleChartSettings
|
| ChartSettingsTitleStyleChartSettings
|
| ColumnFieldListDataSource
|
| ColumnFieldListDataSourceBuilder
|
| ColumnFieldListDataSourceExtends
|
| ColumnsDataSourceSettings
|
| ColumnsDataSourceSettingsExtends
|
| Condition
Defines the conditional formatting operators. They are
|
| DataSourceType
Allows to define the data source type. They are,
|
| EditMode
Allow options for performing CRUD operations with different modes in the data grid that used to update the appropriate cells in the pivot table.
The available modes are as follows:
|
| FieldMappingDataSourceSettings
|
| FieldMappingDataSourceSettingsExtends
|
| FieldMappingFieldListDataSource
|
| FieldMappingFieldListDataSourceBuilder
|
| FieldMappingFieldListDataSourceExtends
|
| FilterFieldListDataSource
|
| FilterFieldListDataSourceBuilder
|
| FilterFieldListDataSourceExtends
|
| FiltersDataSourceSettings
|
| FiltersDataSourceSettingsExtends
|
| FilterType
Allows you to set the specific filter type to display the filter members in the pivot table. They are:
|
| GrandTotalsPosition
Allows the grand totals to be displayed in either the top or bottom position in the pivot table's row and column axes.
The options available are:
|
| GridLayout
Specifies the layout options for displaying the pivot table in either a compact or tabular format.
The available options are:
Compact: Displays the pivot table in a compact format, merging row headers into a single column.
Tabular: Displays the pivot table in a traditional format with separate columns for row headers, creating a more detailed table format.
|
| GroupType
Defines the group types. They are:
|
| Mode
It defines the field list render modes. The available modes are:
|
| MultipleAxisMode
Allows the chart series to be displayed, depending on the value fields specified, in either a stacked or single chart area.
The options available are:
These chart series will be drawn based on the Y-axis range values calculated from all of the bound value fields.
The first value field in the value axis will be used to format the Y-axis range values.
For example, if the first value field is in currency format and the remaining value fields are in different number formats or no format,
the currency format will be used for the Y-axis range values.
|
| Operators
Defines the conditional operators for filtering settings. They are
|
| PagerPosition
Allows to display the pager UI either at top or bottom of the Pivot Table UI.
The options available are:
|
| PivotAxisBorderPrimaryYAxis
|
| PivotAxisCrosshairTooltipPrimaryYAxis
|
| PivotAxisLabelStylePrimaryYAxis
|
| PivotAxisLineStylePrimaryYAxis
|
| PivotAxisMajorGridLinesPrimaryYAxis
|
| PivotAxisMajorTickLinesPrimaryYAxis
|
| PivotAxisMinorGridLinesPrimaryYAxis
|
| PivotAxisMinorTickLinesPrimaryYAxis
|
| PivotAxisTitleStylePrimaryXAxis
|
| PivotAxisTitleStylePrimaryYAxis
|
| PivotCellSelectionMode
Defines mode of cell selection. The modes available are:
|
| PivotFieldList
|
| PivotFieldListAuthentication
|
| PivotFieldListCalculatedFieldSettings
|
| PivotFieldListConditionalFormatSettings
|
| PivotFieldListCustomGroups
|
| PivotFieldListDataSourceSettings
|
| PivotFieldListDrilledMembers
|
| PivotFieldListFilterSettings
|
| PivotFieldListFormatSettings
|
| PivotFieldListGroupSettings
|
| PivotFieldListRows
|
| PivotFieldListSortSettings
|
| PivotFieldListStyle
|
| PivotFieldListValueSortSettings
|
| PivotView
|
| PivotViewAuthentication
|
| PivotViewCalculatedFieldSettings
|
| PivotViewCellEditSettings
|
| PivotViewChartSettings
|
| PivotViewConditionalFormatSettings
|
| PivotViewConditionalSettings
|
| PivotViewCustomGroups
|
| PivotViewDataSourceSettings
|
| PivotViewDisplayOption
|
| PivotViewDrilledMembers
|
| PivotViewFilterSettings
|
| PivotViewFormatSettings
|
| PivotViewGridSettings
|
| PivotViewGroupingBarSettings
|
| PivotViewGroupSettings
|
| PivotViewHyperlinkSettings
|
| PivotViewPagerSettings
|
| PivotViewPageSettings
|
| PivotViewPivotAxis
|
| PivotViewPivotChartAxisAxisLine
|
| PivotViewPivotChartAxisCrosshairTooltip
|
| PivotViewPivotChartAxisFont
|
| PivotViewPivotChartAxisLabelBorder
|
| PivotViewPivotChartAxisMajorGridLines
|
| PivotViewPivotChartAxisMajorTickLines
|
| PivotViewPivotChartAxisMinorGridLines
|
| PivotViewPivotChartAxisMinorTickLines
|
| PivotViewPivotChartConnectorStyle
|
| PivotViewPivotChartDataLabel
|
| PivotViewPivotChartSeriesAnimation
|
| PivotViewPivotChartSeriesBorder
|
| PivotViewPivotChartSeriesCornerRadius
|
| PivotViewPivotChartSeriesEmptyPointSettings
|
| PivotViewPivotChartSeriesErrorSettings
|
| PivotViewPivotChartSeriesMarkerSettings
|
| PivotViewPivotChartSettingsChartArea
|
| PivotViewPivotChartSettingsCrosshairSettings
|
| PivotViewPivotChartSettingsIndexes
|
| PivotViewPivotChartSettingsLegendSettings
|
| PivotViewPivotChartSettingsMargin
|
| PivotViewPivotPieChartCenter
|
| PivotViewPivotSelectionSettings
|
| PivotViewPivotSeries
|
| PivotViewPivotTooltipSettings
|
| PivotViewPivotZoomSettings
|
| PivotViewRows
|
| PivotViewSegments
|
| PivotViewSortSettings
|
| PivotViewStripLines
|
| PivotViewStyle
|
| PivotViewTrendlines
|
| PivotViewValueSortSettings
|
| PivotViewVirtualScrollSettings
|
| Primary
Allows you to set the primary view to be either table or chart.The available options are:
|
| ProviderType
Allows to set the provider type to identify the given connection is either Relational or SSAS to render the pivot table and field list. The following options are:
|
| RenderMode
Allows to set the mode of rendering the pivot table. They are,
|
| SelectionMode
Defines mode of selection. They are
|
| Sorting
Allows to apply sorting to the specified field either by ascending or descending or JSON order. The types are,
|
| StripLinesPrimaryXAxisBorder
|
| StripLinesPrimaryXAxisTextStyle
|
| StripLinesPrimaryYAxis
|
| StripLinesPrimaryYAxisBorder
|
| StripLinesPrimaryYAxisExtends
|
| StripLinesPrimaryYAxisTextStyle
|
| SubTotalsPosition
Specifies different types of positions that will allow the row and column sub-totals to be displayed at the top or bottom of the header group in the pivot table.
The available options are:
|
| SummaryTypes
Allows to display the values in the pivot table with appropriate aggregations such as sum, product, count, average, etc… The available types are,
|
| TooltipBorder
|
| TooltipTextStyle
|
| ValueFieldListDataSource
|
| ValueFieldListDataSourceBuilder
|
| ValueFieldListDataSourceExtends
|
| ValuesDataSourceSettings
|
| ValuesDataSourceSettingsExtends
|
| View
It defines the view port as either table or chart or both table and chart. The available options are:
|
