Allows specific fields associated with field information that needs to be displayed as aggregated numeric values in 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 row/column/value/filter 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.
Type: Allows to display the values in the pivot table with appropriate aggregations such as sum, product, count, average, etc… Note: It is applicable only for relational data source.
BaseField: Allows you to set the selective field, which used to display the values with either
DifferenceFrom or PercentageOfDifferenceFrom or PercentageOfParentTotal aggregate types. Note: It is applicable only for relational data source.
BaseItem: Allows you to set the selective item of a specific field, which used to display the values with either DifferenceFrom or PercentageOfDifferenceFrom aggregate types.
The selective item should be set the from field specified in the baseField property. Note: It is applicable only for relational 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.
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.
ShowValueTypeIcon: Allows you to show or hide the value type icon of a specific field that used to be displayed in the pivot button of the grouping bar and field list UI.
This value type icon helps to select the appropriate aggregation type to specified value field at 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.
public class PivotViewValues : SfDataBoundComponent
protected override void BuildRenderTree(RenderTreeBuilder __builder)
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.
protected override Task OnInitializedAsync()
A System.Threading.Tasks.Task representing any asynchronous operation.