Filtering Data on the Viewer

You can use the filter above the grid on the pivot grid viewer to select specific items. The grid and chart changes accordingly. You can select single or multiple values from one or more filter dropdown options. The filters also apply progressive filtering if they are dependent on each other.

Note:

After applying filters on the Pivot Grid, if you navigate to a URL or Related Action, and then return to the Pivot Grid, the applied filters will be retained on the Pivot Grid. However, any changes that you make to the Pivot Grid database will not be updated on the retained filter(s).