Filter the data in a PivotDiagram

Each node in a level of a PivotDiagram represents a group of rows in your data source that share a common value. For example, a node for the fourth quarter (Qtr4) would contain all of the numeric data for the rows that have Qtr4 in the Quarter column.

You can use filters to choose which nodes appear in a given level. For example, if the data for the first quarter is no longer of interest, you can conceal the Qtr1 node.

1. In the PivotDiagram window, under Add Category, right-click the data that you want to filter, and then click Configure Column.

2. In the Configure Column dialog box, under Filter, under Show data where category name, select the operations in the leftmost column and type the values into the rightmost column to specify the data that you want to work with.

   Only the nodes with information that meets the criteria that you selected appear in the drawing.

To remove the filter, reset the operations in the leftmost column of the Show data where list to (Select Operation).

Note: If your data source is a SQL Server Analysis Services cube, right-click the item that you want to filter, click Configure Dimension, and in the Configure Dimension dialog box, click Configure Level. In the Configure Level dialog box, under Filter, under Show data where category name, select the operations in the list provided to specify the criteria that you want to work with.

For more information about PivotDiagrams, see Create a PivotDiagram.