Excel: Your Manager Wants Your Report Changed

This page is an advertiser-supported excerpt of the book, Power Excel 2010-2013 from MrExcel - 567 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.


Problem: I presented my first pivot table report, shown previously, to my manager. He said, "œThis is almost perfect, but could you have the products going across the top and the regions going down the side?"

Strategy: Pivot tables make this change easy:

  1. On the worksheet, select one cell within the pivot table. Excel will display the PivotTable Field List dialog.
  2. In the dialog, drag the Region field from the Column Labels drop zone to the Row Labels drop zone. In this case, it does not matter if you drop the Region field above or below the Product field
  3. In the dialog, drag the Product field from the Row Labels drop zone to the Column Labels drop zone.

Results: With two movements of the mouse, you have created a new report for your manager.

  1. Move two fields to create a new report.

    The first amazing feature of pivot tables is that they can summarize massive amounts of data very quickly. This topic shows the second amazing feature: Pivot tables can be quickly changed to show another view of the data.