ASP.NET Core - EJ2

Upgrade Guide User Guide Demos Support Forums Download
  • 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

    ChartSettingsBorderChartSettings
    ChartSettingsPrimaryYAxisChartSettings
    ChartSettingsSubTitleStyleChartSettings
    ChartSettingsTitleStyleChartSettings
    ColumnFieldListDataSource
    ColumnFieldListDataSourceBuilder
    ColumnFieldListDataSourceExtends
    ColumnsDataSourceSettings
    ColumnsDataSourceSettingsExtends
    FieldMappingDataSourceSettings
    FieldMappingDataSourceSettingsExtends
    FieldMappingFieldListDataSource
    FieldMappingFieldListDataSourceBuilder
    FieldMappingFieldListDataSourceExtends
    FilterFieldListDataSource
    FilterFieldListDataSourceBuilder
    FilterFieldListDataSourceExtends
    FiltersDataSourceSettings
    FiltersDataSourceSettingsExtends
    PivotAxisBorderPrimaryYAxis
    PivotAxisCrosshairTooltipPrimaryYAxis
    PivotAxisLabelStylePrimaryYAxis
    PivotAxisLineStylePrimaryYAxis
    PivotAxisMajorGridLinesPrimaryYAxis
    PivotAxisMajorTickLinesPrimaryYAxis
    PivotAxisMinorGridLinesPrimaryYAxis
    PivotAxisMinorTickLinesPrimaryYAxis
    PivotAxisTitleStylePrimaryXAxis
    PivotAxisTitleStylePrimaryYAxis
    PivotFieldList
    PivotFieldListAuthentication
    PivotFieldListAuthenticationBuilder
    PivotFieldListBuilder
    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
    PivotViewBuilder
    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
    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
    StripLinesPrimaryXAxisBorder
    StripLinesPrimaryXAxisTextStyle
    StripLinesPrimaryYAxis
    StripLinesPrimaryYAxisBorder
    StripLinesPrimaryYAxisExtends
    StripLinesPrimaryYAxisTextStyle
    TooltipBorder
    TooltipTextStyle
    ValueFieldListDataSource
    ValueFieldListDataSourceBuilder
    ValueFieldListDataSourceExtends
    ValuesDataSourceSettings
    ValuesDataSourceSettingsExtends

    Enums

    ChartSelectionMode

    Defines the pivot chart selection mode. They are None - Disable the selection. Series - To select a series. Point - To select a point. Cluster - To select a cluster of point. DragXY - To select points, by dragging with respect to both horizontal and vertical axis. DragY - To select points, by dragging with respect to vertical axis. DragX - To select points, by dragging with respect to horizontal axis.

    ChartSeriesType

    Defines the pivot chart types. The available chart types are: Line - Allows to display the pivot chart with line series. Column - Allows to display the pivot chart with column series. Area - Allows to display the pivot chart with area series. Bar - Allows to display the pivot chart with bar series. StackingColumn - Allows to display the pivot chart with stacked column series. StackingArea - Allows to display the pivot chart with stacked area series. StackingBar - Allows to display the pivot chart with stacked bar series. StepLine - Allows to display the pivot chart with step line series. StepArea - Allows to display the pivot chart with step area series. SplineArea - Allows to display the pivot chart with spline area series. Scatter - Allows to display the pivot chart with scatter series. Spline - Allows to display the pivot chart with spline series. StackingColumn100 - Allows to display the pivot chart with 100% stacked column series. StackingBar100 - Allows to display the pivot chart with 100% stacked bar series. StackingArea100 - Allows to display the pivot chart with 100% stacked area series. Bubble - Allows to display the pivot chart with bubble series. Pareto - Allows to display the pivot chart with pareto series. Polar - Allows to display the pivot chart with polar series. Radar - Allows to display the pivot chart with radar series.

    Condition

    Defines the conditioanal formatting operators. They are Equals - Display the pivot table that matches with the given text or value or date. DoesNotEquals - Display the pivot table that does not match with the given text or value or date. GreaterThan - Display the pivot table when the text or value is greater. GreaterThanOrEqualTo - Display the pivot table when the text or value is greater than or equal. LessThan - Display the pivot table when the text or value is lesser. LessThanOrEqualTo - Display the pivot table when the text or value is lesser than or equal. Between - Display the pivot table that records between the start and end text or value or date. NotBetween - Display the pivot table that does not record between the start and end text or value or date.

    DataSourceType

    Allows to define the data source type. They are, JSON: Defines JSON type of data source. CSV: Defines CSV or string[][] type of data source.

    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: Normal - Allows the currently selected row alone will be completely changed to edit state. You can change the cell values and save it to the data source by clicking “Update” toolbar button. Dialog - Allows the currently selected row data will be shown in an exclusive dialog. You can change the cell values and save it to the data source by clicking “Save” button in the dialog. Batch - Allows you to perform double-click on any data specific cell in the data grid, the state of that selected cell will be changed to edit state.

    FilterType

    Allows you to set the specific filter type to display the filter members in the pivot table. They are: Include - Specifies the filter type as include for member filter. Exclude - Specifies the filter type as exclude for member filter. Label - Specifies the filter type as label for header filter. Date - Specifies the filter type as date for date based filter. Number - Specifies the filter type as number for number based filter. Value - Specifies the filter type as value for value based filter.

    GroupType

    Defines the group types. They are: Date - Defines group type as 'Date' for date type field Number - Defines group type as 'Number' for numeric type field. Custom - Defines group type as 'Custom' for custom group field.

    Mode

    It defines the field list render modes. The available modes are: Fixed - To display the field list icon in pivot table UI to invoke the built-in dialog. Popup - To display the field list in a static position within a web page.

    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: Stacked: Allows the chart series to be displayed in a separate chart area depending on the value fields specified. Single: Allows the chart series to be displayed in a single chart area for different value fields.

    Operators

    Defines the conditional operators for filtering settings. They are Equals - Display the pivot table that matches with the given text or value or date. DoesNotEquals - Display the pivot table that does not match with the given text or value or date. BeginWith - Display the pivot table that begins with text. DoesNotBeginWith - Display the pivot table that does not begins with text. EndsWith - Display the pivot table that ends with text. DoesNotEndsWith - Display the pivot table that does not ends with text. Contains - Display the pivot table that contains text. DoesNotContains - Display the pivot table that does not contain text. GreaterThan - Display the pivot table when the text or value is greater. GreaterThanOrEqualTo - Display the pivot table when the text or value is greater than or equal. LessThan - Display the pivot table when the text or value is lesser. LessThanOrEqualTo - Display the pivot table when the text or value is lesser than or equal. Before - Display the pivot table with preview all records from the given date. BeforeOrEqualTo - Display the pivot table with previous all records along with the given date. After - Display the pivot table with next all records to the given date. AfterOrEqualTo - Display the pivot table with next all records along with the given date. Between - Display the pivot table that records between the start and end text or value or date. NotBetween - Display the pivot table that does not record between the start and end text or value or date.

    PivotCellSelectionMode

    Defines mode of cell selection. The modes available are: Flow - Allows the range of cells to be selected between the start index and the end index, which also includes the other cells of the selected rows in the pivot table. Box - Allows you to select a range of cells within the starting and ending column indexes that are included in the range between row cells in the pivot table. BoxWithBorder - Allows the range of cells to be selected as the box mode, but along with the borders in the pivot table.

    Primary

    Allows you to set the primary view to be either table or chart.The available options are: Table - Allows you to display the pivot table as primary view. Chart - Allows you to display the pivot chart as primary view.

    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: Relational - Allows to render the pivot table with JSON data collection either fetch at local or remote server. SSAS - Allows to render the pivot table with OLAP data fetch from OLAP cube.

    RenderMode

    Allows to set the mode of rendering the pivot table. They are, Local: Defines the data source in client side and the aggregation done in the same. Server: Defines the data source in server side (WebAPI) and the aggregation done in the same. Only the rendering part alone done in client side.

    SelectionMode

    Defines mode of selection. They are Cell - Defines SelectionMode to Cell. Row - Defines SelectionMode to Row. Column - Defines SelectionMode to Column. Both - Defines SelectionMode to both Row and Column.

    Sorting

    Allows to apply sorting to the specified field either by ascending or descending or JSON order. The types are, Ascending - Allows to display the field members in ascending order. Descending - Allows to display the field members in descending order. None - It allows to display the field members based on JSON order.

    SummaryTypes

    Allows to display the values in the pivot table with appropriate aggregations such as sum, product, count, average, etc… The available types are, Sum - Allows to display the pivot table values with sum. Product - Allows to display the pivot table values with product. Count - Allows to display the pivot table values with count. DistinctCount - Allows to display the pivot table values with distinct count. Min - Allows to display the pivot table with minimum value. Max - Allows to display the pivot table with maximum value. Avg - Allows to display the pivot table values with average. Median - Allows to display the pivot table values with median. Index - Allows to display the pivot table values with index. PopulationStDev - Allows to display the pivot table values with population standard deviation. SampleStDev - Allows to display the pivot table values with sample standard deviation. PopulationVar - Allows to display the pivot table values with population variance. SampleVar - Allows to display the pivot table values with sample variance. RunningTotals - Allows to display the pivot table values with running totals. DifferenceFrom - Allows to display the pivot table values with difference from the value of the base item in the base field. PercentageOfDifferenceFrom - Allows to display the pivot table values with percentage difference from the value of the base item in the base field. PercentageOfGrandTotal - Allows to display the pivot table values with percentage of grand total of all values. PercentageOfColumnTotal - Allows to display the pivot table values in each column with percentage of total values for the column. PercentageOfRowTotal - Allows to display the pivot table values in each row with percentage of total values for the row. PercentageOfParentTotal - Allows to display the pivot table values with percentage of total of all values based on selected field. PercentageOfParentColumnTotal - Allows to display the pivot table values with percentage of its parent total in each column. PercentageOfParentRowTotal - Allows to display the pivot table values with percentage of its parent total in each row. CalculatedField - Allows to display the pivot table with calculated field values. It allows user to create a new calculated field alone.

    View

    It defines the view port as either table or chart or both table and chart. The available options are: Table - To render the component as tabular form. Chart - To render the component as graphical format. Both - To render the component as both table and chart.

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