How to Filter a Data View in Pivot Grid

To display the filtered values (which have been filtered through DataView) in the pivotfilter dialog box as in the pivotrows instead of all the values.

Example:

PivotGrid which binds the DataView created with filtering the Unit Price by checking the condition ‘>=20’ through the below code:

C#

Figure: PivotGrid with Filterdialog shows all the values instead of only the filtered values

Figure: PivotGrid with Filterdialog shows only the filtered values which has been filtered through the DataView