Excel: Building the Pivot Table

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.


Choose fields from any table and drag them to the four drop zones at the bottom of the field list. Since you've created relationships, you are free to use fields from any table.

The pivot table below has region from the Geography table, Excel version from the Product table, Revenue from the Fact table, and a Year slicer from the Date table.

  1. Reporting from four worksheets without doing a VLOOKUP.