Exam 77-427 Microsoft Excel 2013 EXPERT
4. Create Advanced Charts and Tables
4.2   Create and Manage PivotTables: Format Data (Design)

PivotTable: Report Layout

There are several Report Layouts that you should consider. The goal of any PivotTable is to display the data. Depending on the data, some of the layouts make sense while others seem confusing.

Before You Begin: Select the PivotTable.
The PivotTable Tools should be available.

1. Try This: Edit the Field List
Rows: Category, then Product
Columns: Month
Values: Sum of Amount

Keep going, please...
graphic1

PivotTable Tools ->Design-> Layout

graphic2

 
 

pic1