PivotTable: Report Layout

2. What Do You See? The PivotTable now has subgroups for each Category. The monthly sales numbers are calculated and displayed in the Columns.


What Else Do You See? The Column and Row Labels have Filters. The (blank) data has been filtered.


OK, that's the setup for this PivotTable. Let's investigate a few of the Report Layouts. Keep going, please...


Memo to Self: These numbers may look odd because they are not formatted for currency.

PivotTable Tools ->Design-> Layout->Report Layout

Exam 77-888: Microsoft Excel Expert 2010

3. Presenting Data Visually

3.3. Apply and manipulate PivotTables: Report Layout