officefileapi-devexpress-dot-spreadsheet-dot-pivotviewoptions-b933243d.md
Gets or sets a value indicating whether the expand/collapse buttons should be displayed in a pivot table.
Namespace : DevExpress.Spreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
bool ShowDrillIndicators { get; set; }
Property ShowDrillIndicators As Boolean
| Type | Description |
|---|---|
| Boolean |
true , to display drill indicators; otherwise, false.
|
You can access this nested property as listed below:
| Object Type | Path to ShowDrillIndicators |
|---|---|
| PivotTable |
.View .ShowDrillIndicators
|
The expand and collapse buttons are displayed in a multi-layered PivotTable report by default and allow end-users to expand or collapse items within the pivot table. However, you can hide these buttons by setting the ShowDrillIndicators property to false.
The images below demonstrate how the ShowDrillIndicators property works.
|
ShowDrillIndicators = true
(the default option)
|
ShowDrillIndicators = false
| | --- | --- | |
|
|
See Also