PivotField.ShowSingleItem(Int32) Method

Displays the specified item in the PivotTable field.

Namespace: DevExpress.Spreadsheet

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

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

void ShowSingleItem(
    int itemIndex
)

VB.NET

Sub ShowSingleItem(
    itemIndex As Integer
)

Parameters

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.

Remarks

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

View Example

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();

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.

Related GitHub Examples

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

Note

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.

C#

wpf-spreadsheet-pivot-table-api-examples/CS/SpreadsheetWPFPivotTableExamples/CodeExamples/PivotTableFilterActions.cs#L17

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

winforms-spreadsheet-pivot-table-api/CS/SpreadsheetPivotTableExamples/CodeExamples/PivotTableFilterActions.cs#L17

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

spreadsheet-document-api-pivot-table-examples/CS/SpreadsheetDocServerPivotAPI/CodeExamples/PivotTableFilterActions.cs#L17

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

VB.NET

wpf-spreadsheet-pivot-table-api-examples/VB/SpreadsheetWPFPivotTableExamples/CodeExamples/PivotTableFilterActions.vb#L18

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

winforms-spreadsheet-pivot-table-api/VB/SpreadsheetPivotTableExamples/CodeExamples/PivotTableFilterActions.vb#L18

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

spreadsheet-document-api-pivot-table-examples/VB/SpreadsheetDocServerPivotAPI/CodeExamples/PivotTableFilterActions.vb#L18

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