Skip to main content

PivotGridGroup.GetUniqueValues(Object[]) Method

Returns the unique child values of the specified group value.

Namespace: DevExpress.XtraPivotGrid

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

NuGet Packages: DevExpress.PivotGrid.Core, DevExpress.Win.Dashboard.Design


public List<object> GetUniqueValues(
    object[] parentValues


Name Type Description
parentValues Object[]

An array of objects that identifies the group value.


Type Description

A collection of the group value‘s child values.


The GetUniqueValues method searches for the data source records which contain parentValues values in the corresponding fields, and returns the collection of unique values contained in the child field in the records.

In the PivotGrid control shown below, calling the GetUniqueValues method returns the following collections:

parentValues array Return collection
1994, Quarter 3 August, September
1994, Quarter 4 October, November, December
1994 Quarter 3, Quarter 4


The following code obtains the unique child values of the ‘1994 - Quarter 4’ group value:

List<object> uniqueChildValues = 
     pivotGridControl1.Groups[0].GetUniqueValues(new object[] {1994, 4});


If the PivotGridControl filters data by OLAP member unique names (controlled by the PivotGridFieldOptions.OLAPFilterByUniqueName and PivotGridOptionsOLAP.FilterByUniqueName options), the GetUniqueValues method returns them instead of field values.

The following code snippets (auto-collected from DevExpress Examples) contain references to the GetUniqueValues(Object[]) 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