Class PivotViewColumn
Allows specific fields associated with field information that needs to be displayed in column axis of pivot table. The following configurations which are applicable are as follows:
Name
: Allows you to set the field name that needs to be displayed in column axis of pivot table.
Caption
: Allows you to set caption to the specific field. It will be used to display instead of its name in pivot table component's UI.
ShowNoDataItems
: Allows you to display all members items of a specific field to the pivot table,
even doesn't have any data in its row/column intersection in data source. Note: It is applicable only for relational data source.
ShowSubTotals
: Allows to show or hide sub-totals to a specific field in column axis of the pivot table.
IsNamedSet
: Allows you to set whether the specified field is a named set or not. In general,
the named set is a set of dimension members or a set expression (MDX query) to be created as a dimension in the SSAS OLAP cube itself. Note: It is applicable only for OLAP data source.
IsCalculatedField
: Allows to set whether the specified field is a calculated field or not.
In general, the calculated field is created from the bound data source or using simple formula with basic arithmetic operators in the pivot table. Note: It is applicable only for OLAP data source.
ShowFilterIcon
: Allows you to show or hide the filter icon of a specific field that used to be displayed on the pivot button of the grouping bar and field list UI.
This filter icon is used to filter the members of a specified field at runtime in the pivot table.
ShowSortIcon
: Allows you to show or hide the sort icon of a specific field that used to be displayed in the pivot button of the grouping bar and field list UI.
This sort icon is used to order members of a specified field either in ascending or descending at runtime.
ShowRemoveIcon
: Allows you to show or hide the remove icon of a specific field that used to be displayed in the pivot button of the grouping bar and field list UI.
This remove icon is used to remove the specified field during runtime.
ShowEditIcon
: Allows you to show or hide the edit icon of a specific field that used to be displayed on the pivot button of the grouping bar and field list UI.
This edit icon is used to modify caption, formula, and format of a specified calculated field at runtime that to be displayed in the pivot table.
AllowDragAndDrop
: Allows you to restrict the specific field's pivot button that is used to drag on runtime in the grouping bar and field list UI.
This will prevent you from modifying the current report.
ExpandAll
: Allows you to expand or collapse all of the pivot table's headers for a specific field.
Inherited Members
Namespace: Syncfusion.Blazor.PivotView
Assembly: Syncfusion.Blazor.dll
Syntax
public class PivotViewColumn : PivotFieldOptions
Constructors
PivotViewColumn()
Declaration
public PivotViewColumn()
Methods
Dispose(Boolean)
Dispose unmanaged resources in the component.
Declaration
protected override void Dispose(bool disposing)
Parameters
Type | Name | Description |
---|---|---|
System.Boolean | disposing |
OnInitializedAsync()
Method invoked when the component is ready to start, having received its initial parameters from its parent in the render tree. Override this method if you will perform an asynchronous operation and want the component to refresh when that operation is completed.
Declaration
protected override Task OnInitializedAsync()
Returns
Type | Description |
---|---|
System.Threading.Tasks.Task | A System.Threading.Tasks.Task representing any asynchronous operation. |
OnParametersSetAsync()
Method invoked when the component has received parameters from its parent in the render tree, and the incoming values have been assigned to properties.
Declaration
protected override Task OnParametersSetAsync()
Returns
Type | Description |
---|---|
System.Threading.Tasks.Task | A System.Threading.Tasks.Task representing any asynchronous operation. |