Namespace Syncfusion.EJ2.Pivot

Classes

AggregateEventArgs The aggregate event arguments provide the necessary information on each pivot value cell framing in the pivot engine for pivot table render.

AuthenticationInfo Allows you to set the credential information to access the specified SSAS cube. It is applicable only for OLAP data source.

AxisSet Allows you to configure the pivot cell information retrieved from the data source.

CalculatedFields Configures the specific calculated field infomation.

CalculatedFieldSettings Allows options to create new calculated fields from the bound data source or using simple formula with basic arithmetic operators in the pivot table.

ConditionalFormatSettings Allows a collection of values fields to change the appearance of the pivot table value cells with different style properties such as background color, font color, font family, and font size based on specific conditions.

CustomGroups Allows to specify the custom group information of specific field to create custom groups.

DataOptions Allows the following pivot report information such as rows, columns, values, filters, etc., that are used to render the pivot table and field list.

DateMembers It allow to set date members information.

DrilledItem Allows you to configure the drill information of a specific field item that used to display the pivot table.

DrillOptions Allows specific fields used to display their the headers to be either expanded or collapsed in the pivot table.

ExcelExportProperties Defines the options for customizing the excel document during export.

Field Allows you to configure the information retrieved from the data source for the field list.

FieldOptions Allows specific fields associated with field information that needs to be displayed in the field axes of pivot table. The following configurations which are applicable are as follows:

Filter Allows specific fields associated with either selective or conditional-based filter members that used to be displayed in the pivot table.

FormatSettings Allows specific fields used to display the values with specific format that used to be displayed in the pivot table. For example, to display a specific field with currency formatted values in the pivot table, the set the format property to be C.

GroupSettings Allows specific fields to group their data on the basis of their type. For example, the date type fields can be formatted and displayed based on year, quarter, month, and more. Likewise, the number type fields can be grouped range-wise, such as 1-5, 6-10, etc. You can perform custom group to the string type fields that used to displayed in the pivot table.

Members It allow to set members information.

PageSettings Allows to set the page infomration to display the pivot table with specific page during virual scrolling.

PivotEngine<TValue> PivotEngine class is used to manipulate the relational or Multi-Dimensional data as pivoting values to render the pivot table.

Sort Allows specific fields associated with sort settings to order their members either in ascending or descending that used to be displayed in the pivot table.

Style Allows the style information to cusotmize the pivot table cell apprearance.

TemplateContext

TreeDataInfo

ValueMatrixInfo

ValueSortSettings Allows to sort individual value field and its aggregated values either in row or column axis to ascending or descending order.

Enums

AggregateTypes 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. 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.

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.

DataMode Describes the data mode of the pivot table.

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.

DataType Describes the data type of the pivot table.

DateGroup Defines group of date field. They are: Years - Defines group field as 'Years' for date type field. Quarters - Defines group field as 'Quarters' for date type field. QuarterYear - Defines group field as 'Quarter Year' for date type field. Months - Defines group field as 'Months' for date type field. Days - Defines group field as 'Days' for date type field. Hours - Defines group field as 'Hours' for date type field. Minutes - Defines group field as 'Minutes' for date type field. Seconds - Defines group field as 'Seconds' for date type field.

DateOperators Defines the conditional operators for date type fields. 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. 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.

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.

FormatType Defines the format types. They are: Number - Defines format type as 'Number' for numeric type field. Date - Defines format type as 'DateTime' for date type field.

GrandTotalsPosition Allows the grand totals to be displayed at the top or bottom of the pivot table’s row and column axis. By default, the grand totals are displayed at the bottom of 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 axis. Top - Allows the grand totals to be displayed in top position in the pivot table's row and column axis.

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.

LabelOperators Defines the conditional operators for string type fields. 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. 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.

LabelPosition Defines the data label position. They are, Outer: Positions the label outside the point. Top: Positions the label on top of the point. Bottom: Positions the label at the bottom of the point. Middle: Positions the label to the middle of the point. Auto: Positions the label based on series.

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 Defines the mode of displaying the chart series that are created from different measures. They are Stacked - Separates the chart series of different measures and display them in their own chart area.br/> Grouped - Group the chart series of different measures and display them in a single chart area.

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.

PdfBorderStyle Defines border style to PDF export file. They are Solid - Export as PDF with solid type border. Dash - Export as PDF with dash type border. Dot - Export as PDF with dot type border. DashDot - Export as PDF with dashdot type border. DashDotDot - Export as PDF with dashdotdot type border.

PivotAccumulationChartSelectionMode Defines the SelectionMode for chart types pie, doughnut, Funnel and pyramid. None - Disable the selection. Point - To select a point.

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.

PivotChartAlignment Defines the Alignment. They are Near - Align the element to the left. Center - Align the element to the center. Far - Align the element to the right.

PivotChartAnchor Defines the strip line text position. Start - Places the strip line text at the start. Middle - Places the strip line text in the middle. End - Places the strip line text at the end.

PivotChartAxisPosition Defines the Position. They are inside - Place the ticks or labels inside to the axis line. outside - Place the ticks or labels outside to the axis line.

PivotChartBorderType Defines border type for multi level labels. Rectangle - Shows chart border as rectangle. Brace - Shows chart border as braces. WithoutBorder - Shows chart without border. Without top Border - Shows chart with border on its top. Without top and bottom border - Shows chart with border on its top and bottom. Curly brace - Shows chart with curly braces.

PivotChartConnectorType Defines the ConnectorType for chart types pie, doughnut, Funnel and pyramid. They are Line - Accumulation series Connector line type as Straight line. Curve - Accumulation series Connector line type as Curved line.

PivotChartDrawType Type of series to be drawn in radar or polar series. They are line - Renders the line series. column - Renders the column series. area - Renders the area series. scatter - Renders the scatter series. spline - Renders the spline series. stackingColumn - Renders the stacking column series. stackingArea - Renders the stacking area series. rangeColumn - Renders the range column series. splineArea - Renders the spline area series.

PivotChartEdgeLabelPlacement Defines the Edge Label Placement for an axis. They are none - No action will be perform. hide - Edge label will be hidden. shift - Shift the edge labels.

PivotChartEmptyPointMode Defines the empty point mode of the chart. Gap - Used to display empty points as space. Zero - Used to display empty points as zero. Drop - Used to ignore the empty point while rendering. Average - Used to display empty points as previous and next point average.

PivotChartErrorBarDirection Defines the direction of error bar. They are Both - Renders both direction of error bar. Minus - Renders minus direction of error bar. Plus - Renders plus direction error bar.

PivotChartErrorBarMode Defines the modes of error bar. They are Vertical - Renders a vertical error bar. Horizontal - Renders a horizontal error bar. Both - Renders both side error bar.

PivotChartErrorBarType Defines the type of error bar. They are Fixed - Renders a fixed type error bar. Percentage - Renders a percentage type error bar. StandardDeviation - Renders a standard deviation type error bar. StandardError - Renders a standard error type error bar. Custom - Renders a custom type error bar.

PivotChartGroupModes Defines the mode of the group mode for chart types pie, doughnut, Funnel and pyramid Point - When choosing points, the selected points get grouped. Value - When choosing values, the points which less then values get grouped.

PivotChartLabelIntersectAction Defines the Alignment. They are None - Shows all the labels. Hide - Hide the label when it intersect. Rotate45 - Rotate the label to 45 degree when it intersect. Rotate90 - Rotate the label to 90 degree when it intersect.

PivotChartLabelPlacement Defines the Label Placement for category axis. They are BetweenTicks - Render the label between the ticks. OnTicks - Render the label on the ticks.

PivotChartLabelPosition Defines the LabelPosition for chart types pie, doughnut, Funnel and pyramid. They are Inside - Define the data label position for the accumulation series Inside. Outside - Define the data label position for the accumulation series Outside.

PivotChartLegendPosition Defines the position of the legend. They are Auto - Places the legend based on area type. Top - Displays the legend on the top of chart. Left - Displays the legend on the left of chart. Bottom - Displays the legend on the bottom of chart. Right - Displays the legend on the right of chart. Custom - Displays the legend based on given x and y value.

PivotChartLegendShape Defines the shape of legend. They are Circle - Renders a circle. Rectangle - Renders a rectangle. Triangle - Renders a triangle. Diamond - Renders a diamond. Cross - Renders a cross. HorizontalLine - Renders a horizontalLine. VerticalLine - Renders a verticalLine. Pentagon - Renders a pentagon. InvertedTriangle - Renders a invertedTriangle. SeriesType -Render a legend shape based on series type.

PivotChartLineType Defines the mode of line in crosshair. They are None - Hides both vertical and horizontal crosshair line. Both - Shows both vertical and horizontal crosshair line. Vertical - Shows the vertical line. Horizontal - Shows the horizontal line.

PivotChartPyramidModes Defines the mode of the pyramid Linear - Height of the pyramid segments reflects the values Surface - Surface/Area of the pyramid segments reflects the values.

PivotChartShape Defines the shape of marker. They are Circle - Renders the marker shaper as circle. Rectangle - Renders the marker shaper as rectangle. Triangle - Renders the marker shaper as triangle. Diamond - Renders the marker shaper as diamond. Cross - Renders the marker shaper as cross. HorizontalLine - Renders the marker shaper as horizontalLine. VerticalLine - Renders the marker shaper as verticalLine. Pentagon- Renders the marker shaper as pentagon. InvertedTriangle - Renders the marker shaper as invertedTriangle. Image - Renders the marker shaper as image.

PivotChartSizeType Defines the unit of Strip line Size. They are Auto - In numeric axis, it will consider a number and DateTime axis, it will consider as milliseconds. Pixel - The stripline gets their size in pixel. Year - The stipline size is based on year in the DateTime axis. Month - The stipline size is based on month in the DateTime axis. Day - The stipline size is based on day in the DateTime axis. Hour - The stipline size is based on hour in the DateTime axis. Minutes - The stipline size is based on minutes in the DateTime axis. Seconds - The stipline size is based on seconds in the DateTime axis.

PivotChartSplineType It defines type of spline. Natural - Used to render Natural spline. Cardinal - Used to render cardinal spline. Clamped - Used to render Clamped spline Monotonic - Used to render monotonic spline.

PivotChartTextOverflow Defines the Text overflow. None - Shown the chart title with overlap if exceed. Wrap - Shown the chart title with wrap if exceed. Trim - Shown the chart title with trim if exceed.

PivotChartToolbarItems Defines the ZoomingToolkit, They are. Zoom - Renders the zoom button. ZoomIn - Renders the zoomIn button. ZoomOut - Renders the zoomOut button. Pan - Renders the pan button. Reset - Renders the reset button.

PivotChartTrendlineTypes Defines the type of trendlines. They are: Linear - Defines the linear trendline. Exponential - Defines the exponential trendline. Polynomial - Defines the polynomial trendline. Power - Defines the power trendline. Logarithmic - Defines the logarithmic trendline. MovingAverage - Defines the moving average trendline.

PivotChartZIndex Specifies the order of the strip line. Over | Behind. Over - Places the strip line over the series elements. Behind - laces the strip line behind the series elements.

PivotChartZoomMode Defines the zooming mode, They are. X,Y - Chart will be zoomed with respect to both vertical and horizontal axis. X - Chart will be zoomed with respect to horizontal axis. Y - Chart will be zoomed with respect to vertical axis.

PivotTableCheckboxSelectionType Defines modes of checkbox Selection. They are: Default - Allows multiple rows to be selected by clicking rows one by one. ResetOnRowClick - Allows to reset the previously selected row when a row is clicked and multiple rows can be selected by using CTRL or SHIFT key.

PivotTableClipMode Defines the cell content's overflow mode. The available modes are Clip - Truncates the cell content when it overflows its area. Ellipsis - Displays ellipsis when the cell content overflows its area. EllipsisWithTooltip - Displays ellipsis when the cell content overflows its area also it will display tooltip while hover on ellipsis applied cell.

PivotTableContextMenuItem Defines the pivot table context menu items. They are Drillthrough - Enables drill through for the cell. Expand - Expands the cell. Collapse - Collapse the cell. CalculatedField - Enables calculated field for the pivot grid. Pdf Export - Export the grid as Pdf format. Excel Export - Export the grid as Excel format. Csv Export - Export the grid as CSV format. Sort Ascending - Sort the current column in ascending order. Sort Descending - Sort the current column in descending order. Aggregate - Sets aggregate type to sum.

PivotTableGridLine Defines modes of GridLine, They are Both - Show both the vertical and horizontal line in the Grid. None - Hide both the vertical and horizontal line in the Grid. Horizontal - Shows the horizontal line only in the Grid. Vertical - Shows the vertical line only in the Grid. Default - Shows the grid lines based on the theme.

PivotTablePrintMode Print mode options are AllPages - Print all pages records of the Grid. CurrentPage - Print current page records of the Grid.

PivotTableSelectionType Defines types of Selection. They are: Single - Allows the user to select a row or cell on their own in the pivot table. Multiple - Allows the user to select multiple rows or columns or cells 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.

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.

SubTotalsPosition Allows the sub-totals to be displayed at the top or bottom of their header group in the pivot table’s row and column axes. The options available are: None - Allows the sub-totals to be displayed at their default position. Top - Allows the sub-totals to be displayed at the top position of the header group in the pivot table's row and column axes. Bottom - Allows the sub-totals to be displayed in bottom position of the header group in the pivot table's row and column axes. Note: By default, the column sub-totals are displayed at the bottom and row sub-totals are displayed at the top of their header group in the pivot table’s row and column axes.

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. 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.

ToolbarItems Allows the built-in toolbar options that used to access features like switching between pivot table and pivot chart, changing chart types, conditional formatting, number formatting, exporting, etc… with ease at runtime. The available toolbar options are: New - Allows to create a new report. Save - Allows to save the current report. Save As - Allows to perform save as the current report. Rename - Allows to rename the current report. Remove - Allows to delete the current report. Load - Allows to load any report from the report list. Grid - Allows to show the pivot table. Chart - Allows to show the pivot chart with specific type from the built-in list. Exporting - Allow set of options to export the pivot table as PDF/Excel/CSV and the pivot chart as PDF and image format such as PNG, JPEG, SVG. Sub-total - Allow set of options to show or hide the sub totals in the pivot table. The subtotals will not be displayed in the pivot chart by default. Grand Total - Allow set of options to show or hides the grand totals in the pivot table. By default, the grand totals will not be displayed in the pivot chart. Conditional Formatting - Allows to show the conditional formatting pop-up to apply formatting to the values. Number Formatting - Allows to show the number formatting pop-up to apply number formatting to the values. Formatting - Allow options to show the conditional formatting and the number formatting pop-up that used to apply formatting to the values in the component. Field List - Allows you to show the field list pop-up. It allows you to modify the report with a variety of actions such as re-arrange the fields between axes by drag-and-drop, add new fields to report, remove any fields from report, filtering and sorting a specific field members, etc., that are used to update the pivot table during runtime. MDX - Allows ro show the MDX query that was run to retrieve data from the OLAP data source. Note: It is applicable only for OLAP data source.

ValueOperators Defines the conditional operators for value type fields. 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.

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.

WrapMode Defines the wrap mode for pivot table. Both - Wraps both the header and content. Header - Wraps header alone. Content - Wraps content alone.