Skip to main content
.NET Framework 4.5.2+

PivotField.ShowSingleItem(Int32) Method

Displays the specified item in the PivotTable field.

Namespace: DevExpress.Spreadsheet

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


void ShowSingleItem(
    int itemIndex


Name Type Description
itemIndex Int32

A zero-based integer value that specifies the index of the item to be displayed. If it’s negative or exceeds the number of items in the field, an exception is raised.


Use the ShowSingleItem method to display a particular item in a PivotTable field located in a row, column or page area.

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).

You can also control the visibility of field items by setting the PivotItem.Visible property to the required value for each item you wish to hide or display.

To restore the display of all hidden items in a pivot field, call the PivotField.ShowAllItems method.

The following code snippets (auto-collected from DevExpress Examples) contain references to the ShowSingleItem(Int32) method.


The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

See Also