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#
DataView dataView = new DataView(ds.Tables[0], "[Unit Price] >= 20", "[Order ID]", DataViewRowState.CurrentRows);
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
