Read Excel Tips Such As How To Summarize Pivot Table Data By Three Measures At BrightHub.com

Strategy:

Several views of the data are possible. From the PivotTable Field List, drag the Region field and drop it in the Row area of the pivot table, to the left of the Customer field, as shown in Fig. 882.

Another option is to drag the third measure to the Column area of the pivot table, as shown in Fig. 883.

Even with this view, the report looks different if you move the Region field and drop it to the right of the Product field, as shown in Fig. 884.

Summary: You can use more than one field along either the row or column axis of the pivot table to produce more complex summaries.

Images

Fig. 882
Fig. 883
Fig. 884