Using Value Filters

A common analysis scenario is comparing the maximum unit prices of selected products across multiple salespersons.

For example, a user may want to analyze the maximum unit prices for the products Boston Crab Meat, Filo Mix, and Ipoh Coffee sold by the salespersons Andrew Fuller, Laura Callahan, Margaret Peacock, and Robert King.

This scenario can be implemented by applying value filters to the Salesperson and Product Name fields in the underlying data source.

The following image shows a FlexPivotGrid displaying the maximum unit prices for the selected products and salespersons:

Configure Value Filtering in FlexPivotGrid

The following steps demonstrate how to apply value filtering in FlexPivotGrid. This example uses the sample created in the Binding FlexPivot to Data Source in Code topic.

Step 1: Configure Pivot Fields

Add the following fields to the pivot layout:

• Add Salesperson and ProductName to the Rows area.

• Add UnitPrice to the Values area.

Step 2: Filter the Salesperson Field

1. Right-click the Salesperson field in the Rows area.

2. Select Field Settings to open the configuration dialog.

3. Select the following salespersons:

   • Andrew Fuller

   • Laura Callahan

   • Margaret Peacock

   • Robert King

Step 3: Filter the ProductName Field

1. Right-click the ProductName field in the Rows area.

2. Select Field Settings.

3. Select the following products:

   • Boston Crab Meat

   • Filo Mix

   • Ipoh Coffee

Step 4: Configure the Value Aggregation

1. Right-click the UnitPrice field in the Values area.

2. Select Field Settings.

3. Open the Subtotals tab.

4. Select Maximum as the aggregation function.

After applying these settings, FlexPivotGrid displays the maximum unit prices for the selected products grouped by the selected salespersons.