wpf-devexpress-dot-xpf-dot-pivotgrid-dot-pivotgridgroup-dot-getuniquevalues-x28-system-dot-object-x29.md
Returns the unique child values of the specified group value.
Namespace : DevExpress.Xpf.PivotGrid
Assembly : DevExpress.Xpf.PivotGrid.v25.2.dll
NuGet Package : DevExpress.Wpf.PivotGrid
public List<object> GetUniqueValues(
object[] parentValues
)
Public Function GetUniqueValues(
parentValues As Object()
) As List(Of Object)
| Name | Type | Description |
|---|---|---|
| parentValues | Object[] |
An array of objects that identifies the group value.
|
| Type | Description |
|---|---|
| List<Object> |
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});
Dim uniqueChildValues As List(Of Object) = _
pivotGridControl1.Groups(0).GetUniqueValues(New Object() {1994, 4})
Note
If the PivotGridControl filters data by OLAP member unique names (controlled by the PivotGridField.OlapFilterByUniqueName and PivotGridControl.OlapFilterByUniqueName options), the GetUniqueValues method returns them instead of field values.
See Also