Skip to main content
.NET Framework 4.5.2+

PivotField.ShowAllItems() Method

Displays all items in the PivotTable field.

Namespace: DevExpress.Spreadsheet

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


void ShowAllItems()


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

View Example

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.

'Show all items in the "Product" field (the default option).
See Also