Namespace Syncfusion.EJ2.PivotView
Classes
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. |
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: Top: Allows the grand totals to be displayed in top position in the pivot table's row and column axes. Bottom: Allows the grand totals to be displayed in bottom position in the pivot table's row and column axes. |
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. |