corelibraries-devexpress-dot-xtrapivotgrid-dot-pivotgridfieldoptions-54b9c2f1.md
Gets or sets whether the first (empty) column/row that displays variation data for the current data field must be hidden.
Namespace : DevExpress.XtraPivotGrid
Assembly : DevExpress.PivotGrid.v25.2.Core.dll
NuGet Packages : DevExpress.PivotGrid.Core, DevExpress.Win.Navigation
[DefaultValue(false)]
public bool HideEmptyVariationItems { get; set; }
<DefaultValue(False)>
Public Property HideEmptyVariationItems As Boolean
| Type | Default | Description |
|---|---|---|
| Boolean | false |
true if the first (empty) column/row that displays variation data for the current data field must be hidden; otherwise, false.
|
You can access this nested property as listed below:
| Object Type | Path to HideEmptyVariationItems |
|---|---|
| PivotGridFieldBase |
.Options .HideEmptyVariationItems
|
If the current field is a data field and the PivotGridFieldBase.SummaryDisplayType property is set to PivotSummaryDisplayType.AbsoluteVariation or PivotSummaryDisplayType.PercentVariation, the corresponding columns/rows display variation data. In this case, the first column/row is always empty. You can hide it via the HideEmptyVariationItems property.
The following code snippet (auto-collected from DevExpress Examples) contains a reference to the HideEmptyVariationItems property.
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.
winforms-pivot-grid-walkthrough-tutorial/CS/WinPivot_GettingStarted/Form1.cs#L21
sqlDataSource1.Fill();
pivotGridField5.Options.HideEmptyVariationItems = true;
pivotGridControl1.BestFit();
winforms-pivot-grid-walkthrough-tutorial/VB/WinPivot_GettingStarted/Form1.vb#L15
sqlDataSource1.Fill()
pivotGridField5.Options.HideEmptyVariationItems = True
pivotGridControl1.BestFit()
See Also