officefileapi-devexpress-dot-spreadsheet-dot-pivotfield-d6e35a75.md
Displays all items in the PivotTable field.
Namespace : DevExpress.Spreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
void ShowAllItems()
Sub ShowAllItems
Use this method to remove a filter applied to the PivotTable field and redisplay all the items in this field.
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();
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();
See Also