Skip to main content
All docs
V25.1
  • DxPivotTable.GetFields() Method

    Returns a collection of Pivot Table fields.

    Namespace: DevExpress.Blazor.PivotTable

    Assembly: DevExpress.Blazor.PivotTable.v25.1.dll

    NuGet Package: DevExpress.Blazor.PivotTable

    Declaration

    public IReadOnlyList<IPivotTableField> GetFields()

    Returns

    Type Description
    IReadOnlyList<IPivotTableField>

    The field collection.

    Remarks

    The following code changes the sort order of the Region field in the BeginUpdate/EndUpdate code block:

    @rendermode InteractiveServer
    
    <DxButton Click="ChangeRegionSortOrder">Change Region Sort Order</DxButton>
    <p/>
    
    <DxPivotTable Data="SalesData"
             @ref="PivotTable">
        <Fields>
            <DxPivotTableField Field="@nameof(Sales.SaleInfo.Region)"
                               Area="@PivotTableArea.Row"
                               AreaIndex="0">
            </DxPivotTableField>
            <DxPivotTableField Field="@nameof(Sales.SaleInfo.Country)"
                               Area="@PivotTableArea.Row"
                               SortOrder="@PivotTableSortOrder.Descending"
                               AreaIndex="1" />
            <DxPivotTableField Field="@nameof(Sales.SaleInfo.Date)"
                               GroupInterval="@PivotTableGroupInterval.DateYear"
                               Area="@PivotTableArea.Column"
                               AreaIndex="0" 
                               Caption="Year" />
            <DxPivotTableField Field="@nameof(Sales.SaleInfo.Date)"
                               GroupInterval="@PivotTableGroupInterval.DateQuarter"
                               Area="@PivotTableArea.Column"
                               AreaIndex="1"
                               Caption="Quarter" />
            <DxPivotTableField Field="@nameof(Sales.SaleInfo.Amount)"
                               SortOrder="@PivotTableSortOrder.Ascending"
                               Area="@PivotTableArea.Data"
                               SummaryType="@PivotTableSummaryType.Sum"/>
        </Fields>
    </DxPivotTable>
    
    @code {
        IPivot PivotTable { get; set; }
        IEnumerable<SaleInfo> SalesData;
        protected override async Task OnInitializedAsync() {
            SalesData = await Sales.GetSalesAsync();
        }
    
        void ChangeRegionSortOrder() {
            PivotTable.BeginUpdate();
    
            PivotTable
                .GetFields()
                .First(f => f.Field == "Region")
                .ChangeSortOrder();
    
            PivotTable.EndUpdate();
        }
    }
    

    Implements

    See Also