Skip to main content Skip to footer

Wijmo OLAP: Filtering Data in a PivotGrid

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:

  1. You can apply a filter directly to the source data. For example, you could retrieve sales data for the last 12 months only, and perform all your analyses based on that subset of the data. The advantage of this approach is you would never download data that won’t be used in the analysis. The drawback is that users would not be able to see any data outside the subset you chose.
  2. You can use filter fields to filter that data using Wijmo Olap. The advantage of this approach is you get complete flexibility over what data should be included in each view. For example, you could create separate views to see sales in different groups of countries.

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.

More from the Wijmo OLAP series

  1. Getting Started with Wijmo's HTML5 OLAP Module: Create Basic Pivot Tables
  2. Answer Recurring Questions with Pre-Defined Views
  3. Filtering Data in a PivotGrid
  4. Exporting a PivotGrid to Excel
  5. Customizing the UI and PivotGrid

See Angular OLAP demo | See JS OLAP Demo


comments powered by Disqus