Sometimes you may want focus on just a certain section of your data. Filters can be used to narrow down the data in your PivotGrid, allowing you to view only the information you need.
Full Wijmo OLAP series:
There are two ways to filter the data in Wijmo Olap:
To filter data using Wijmo Olap, drag the field you want to filter on into the view. For example, in our sales by product example, let us filter out the US sales to see how they affect the overall picture. Start by dragging the “Country” field into the “Filters” list of the PivotPanel (you can apply filters to fields in any other lists as well): Next, right-click the “Country” field, select “Field Settings…” and click the “Filter Edit…” button to set the filter:
You can apply filters by condition or by value. In this case, we will simply uncheck the “US” item from the list and click OK.
The filter icon next to the “Country” field indicates there’s an active filter. After excluding US sales from the analysis, the grand total dropped from about 250 million to 220 million.