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:

This table shows Region, City and Dollars

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.