Aggregation and the Excluded Drop Target

In a pivot table or graph that includes columns in the Excluded drop target, an aggregation rule is applied to aggregate measures in the data body of the view to a single value. For example, suppose that you have the following columns in the Selected Columns pane:

Region	City	Dollars
East	NY	1000
East	Boston	500

If the City column is placed in the Excluded drop target, then the view typically displays the following:

East 1500

The aggregation rule is applied to aggregate 1,000 and 500 into 1,500. In a pivot table or graph, the aggregation rule that is specified in the Edit Column Formula dialog applies. For a pivot table, you can select a specific aggregation rule using the More Options menu in the Layout pane.

Suppose that you wanted the table, pivot table, or graph to show the following values:

East 1000

East 500

To achieve this aggregation, include both Region and City columns in the view layout, but hide the City column using its Column Properties dialog: Column Format tab.