menu

ASP.NET Core - EJ2

  • Code Examples
  • Upgrade Guide
  • User Guide
  • Demos
  • Support
  • Forums
  • Download
Namespace Syncfusion.EJ2.PivotView - ASP.NETCore-EJ2 API Reference | Syncfusion

    Show / Hide Table of Contents

    Namespace Syncfusion.EJ2.PivotView

    Classes

    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
    PivotFieldListAuthenticationBuilder
    PivotFieldListCalculatedFieldSetting
    PivotFieldListCalculatedFieldSettingBuilder
    PivotFieldListCalculatedFieldSettings
    PivotFieldListConditionalFormatSetting
    PivotFieldListConditionalFormatSettingBuilder
    PivotFieldListConditionalFormatSettings
    PivotFieldListCustomGroup
    PivotFieldListCustomGroupBuilder
    PivotFieldListCustomGroups
    PivotFieldListDataSourceSettings
    PivotFieldListDataSourceSettingsBuilder
    PivotFieldListDrilledMember
    PivotFieldListDrilledMemberBuilder
    PivotFieldListDrilledMembers
    PivotFieldListFilterSetting
    PivotFieldListFilterSettingBuilder
    PivotFieldListFilterSettings
    PivotFieldListFormatSetting
    PivotFieldListFormatSettingBuilder
    PivotFieldListFormatSettings
    PivotFieldListGroupSetting
    PivotFieldListGroupSettingBuilder
    PivotFieldListGroupSettings
    PivotFieldListRow
    PivotFieldListRowBuilder
    PivotFieldListRows
    PivotFieldListSortSetting
    PivotFieldListSortSettingBuilder
    PivotFieldListSortSettings
    PivotFieldListStyle
    PivotFieldListStyleBuilder
    PivotFieldListValueSortSettings
    PivotFieldListValueSortSettingsBuilder
    PivotView
    PivotViewAuthentication
    PivotViewAuthenticationBuilder
    PivotViewCalculatedFieldSetting
    PivotViewCalculatedFieldSettingBuilder
    PivotViewCalculatedFieldSettings
    PivotViewCellEditSettings
    PivotViewCellEditSettingsBuilder
    PivotViewChartSettings
    PivotViewChartSettingsBuilder
    PivotViewConditionalFormatSetting
    PivotViewConditionalFormatSettingBuilder
    PivotViewConditionalFormatSettings
    PivotViewConditionalSetting
    PivotViewConditionalSettingBuilder
    PivotViewConditionalSettings
    PivotViewCustomGroup
    PivotViewCustomGroupBuilder
    PivotViewCustomGroups
    PivotViewDataSourceSettings
    PivotViewDataSourceSettingsBuilder
    PivotViewDisplayOption
    PivotViewDisplayOptionBuilder
    PivotViewDrilledMember
    PivotViewDrilledMemberBuilder
    PivotViewDrilledMembers
    PivotViewFilterSetting
    PivotViewFilterSettingBuilder
    PivotViewFilterSettings
    PivotViewFormatSetting
    PivotViewFormatSettingBuilder
    PivotViewFormatSettings
    PivotViewGridSettings
    PivotViewGridSettingsBuilder
    PivotViewGroupingBarSettings
    PivotViewGroupingBarSettingsBuilder
    PivotViewGroupSetting
    PivotViewGroupSettingBuilder
    PivotViewGroupSettings
    PivotViewHyperlinkSettings
    PivotViewHyperlinkSettingsBuilder
    PivotViewPagerSettings
    PivotViewPagerSettingsBuilder
    PivotViewPageSettings
    PivotViewPageSettingsBuilder
    PivotViewPivotAxis
    PivotViewPivotAxisBuilder
    PivotViewPivotChartAxisAxisLine
    PivotViewPivotChartAxisAxisLineBuilder
    PivotViewPivotChartAxisCrosshairTooltip
    PivotViewPivotChartAxisCrosshairTooltipBuilder
    PivotViewPivotChartAxisFont
    PivotViewPivotChartAxisFontBuilder
    PivotViewPivotChartAxisLabelBorder
    PivotViewPivotChartAxisLabelBorderBuilder
    PivotViewPivotChartAxisMajorGridLines
    PivotViewPivotChartAxisMajorGridLinesBuilder
    PivotViewPivotChartAxisMajorTickLines
    PivotViewPivotChartAxisMajorTickLinesBuilder
    PivotViewPivotChartAxisMinorGridLines
    PivotViewPivotChartAxisMinorGridLinesBuilder
    PivotViewPivotChartAxisMinorTickLines
    PivotViewPivotChartAxisMinorTickLinesBuilder
    PivotViewPivotChartConnectorStyle
    PivotViewPivotChartConnectorStyleBuilder
    PivotViewPivotChartDataLabel
    PivotViewPivotChartDataLabelBuilder
    PivotViewPivotChartSeriesAnimation
    PivotViewPivotChartSeriesAnimationBuilder
    PivotViewPivotChartSeriesBorder
    PivotViewPivotChartSeriesBorderBuilder
    PivotViewPivotChartSeriesCornerRadius
    PivotViewPivotChartSeriesCornerRadiusBuilder
    PivotViewPivotChartSeriesEmptyPointSettings
    PivotViewPivotChartSeriesEmptyPointSettingsBuilder
    PivotViewPivotChartSeriesErrorSettings
    PivotViewPivotChartSeriesErrorSettingsBuilder
    PivotViewPivotChartSeriesMarkerSettings
    PivotViewPivotChartSeriesMarkerSettingsBuilder
    PivotViewPivotChartSettingsChartArea
    PivotViewPivotChartSettingsChartAreaBuilder
    PivotViewPivotChartSettingsCrosshairSettings
    PivotViewPivotChartSettingsCrosshairSettingsBuilder
    PivotViewPivotChartSettingsIndexes
    PivotViewPivotChartSettingsIndexesBuilder
    PivotViewPivotChartSettingsLegendSettings
    PivotViewPivotChartSettingsLegendSettingsBuilder
    PivotViewPivotChartSettingsMargin
    PivotViewPivotChartSettingsMarginBuilder
    PivotViewPivotPieChartCenter
    PivotViewPivotPieChartCenterBuilder
    PivotViewPivotSelectionSettings
    PivotViewPivotSelectionSettingsBuilder
    PivotViewPivotSeries
    PivotViewPivotSeriesBuilder
    PivotViewPivotTooltipSettings
    PivotViewPivotTooltipSettingsBuilder
    PivotViewPivotZoomSettings
    PivotViewPivotZoomSettingsBuilder
    PivotViewRow
    PivotViewRowBuilder
    PivotViewRows
    PivotViewSegment
    PivotViewSegmentBuilder
    PivotViewSegments
    PivotViewSortSetting
    PivotViewSortSettingBuilder
    PivotViewSortSettings
    PivotViewStripLine
    PivotViewStripLineBuilder
    PivotViewStripLines
    PivotViewStyle
    PivotViewStyleBuilder
    PivotViewTrendline
    PivotViewTrendlineBuilder
    PivotViewTrendlines
    PivotViewValueSortSettings
    PivotViewValueSortSettingsBuilder
    PivotViewVirtualScrollSettings
    PivotViewVirtualScrollSettingsBuilder
    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:

    Back to top Generated by DocFX
    Copyright © 2001 - 2025 Syncfusion Inc. All Rights Reserved