PivotField.ShowAllItems() Method

Displays all items in the PivotTable field.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v18.2.Core.dll

Declaration

C#

void ShowAllItems()

VB.NET

Sub ShowAllItems

Remarks

Use this method to remove a filter applied to the PivotTable field and redisplay all the items in this field.

Note

A complete sample project is available at https://github.com/DevExpress-Examples/winforms-spreadsheet-pivot-table-api-t298650

PivotTableFilterActions.vb

Dim worksheet As Worksheet = workbook.Worksheets("Report4")
workbook.Worksheets.ActiveWorksheet = worksheet

' Access the pivot table by its name in the collection.
Dim pivotTable As PivotTable = worksheet.PivotTables("PivotTable1")

' Show the first item in the "Product" field.
pivotTable.Fields(1).ShowSingleItem(0)

'Show all items in the "Product" field (the default option).
'pivotTable.Fields[1].ShowAllItems();

PivotTableFilterActions.cs

Worksheet worksheet = workbook.Worksheets["Report4"];
workbook.Worksheets.ActiveWorksheet = worksheet;

// Access the pivot table by its name in the collection.
PivotTable pivotTable = worksheet.PivotTables["PivotTable1"];

// Show the first item in the "Product" field.
pivotTable.Fields[1].ShowSingleItem(0);

//Show all items in the "Product" field (the default option).
//pivotTable.Fields[1].ShowAllItems();