PivotGridWebOptionsFilter.ShowOnlyAvailableItems Property

Gets or sets whether filter items that cannot be displayed because of filtering applied to other fields should be hidden.

Namespace: DevExpress.Web.ASPxPivotGrid

Assembly: DevExpress.Web.ASPxPivotGrid.v20.1.dll

NuGet Package: DevExpress.Web

Declaration

C#

[DefaultValue(false)]
public bool ShowOnlyAvailableItems { get; set; }

VB.NET

<DefaultValue(False)>
Public Property ShowOnlyAvailableItems As Boolean

Property Value

Type	Default	Description
Boolean	false	true to hide filter items that cannot be displayed because of filtering applied to other fields; otherwise, false.

Property Paths

You can access this nested property as listed below:

Object Type	Path to ShowOnlyAvailableItems
ASPxPivotGrid	.OptionsFilter .ShowOnlyAvailableItems
MVCxPivotGrid	.OptionsFilter .ShowOnlyAvailableItems
PivotGridSettings	.OptionsFilter .ShowOnlyAvailableItems

Remarks

The ShowOnlyAvailableItems property allows you to simulate group filter behavior without merging fields into a group. This property is not in effect when you open a filter window for grouped fields.

A filter drop-down window invoked for a particular field contains all the unique field values, although some of these values may actually be excluded from the pivot grid by filtering applied to other fields.

For example, a pivot grid contains two dimension fields: Category Name and Product Name.

If you select only one product category from the Category Name filter drop-down, it excludes all products related to other categories from the pivot grid. This means that whether you check or uncheck any of these products in the Product Name filter drop-down, this has no effect, since they are hidden by category filtering:

To remove such field values from filter drop-downs, set the PivotGridOptionsFilterBase.ShowOnlyAvailableItems property to true: