How to Filter a Data View in Pivot Grid

1 min read

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:

DataView dataView = new DataView(ds.Tables[0], "[Unit Price] >= 20", "[Order ID]", DataViewRowState.CurrentRows);

$D:\documentation\clip_image001529731829.png$

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

$D:\documentation\clip_image003312935872.png$

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

Did you find this information helpful?

Yes

Comments (0)

How to Filter a Data View in Pivot Grid

Access denied