Pin Me

Microsoft Excel: Summarize Pivot Table Data By Three Measures

written by: Mr Excel•edited by: Tricia Goss•updated: 11/18/2011

Problem: You want to summarize data by Region, Product, and Customer. How can a two-dimensional report show three dimensions of data?

  • slide 1 of 2

    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.

  • slide 2 of 2

    Images

    Fig. 882Fig. 883Fig. 884