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
|
|
| |
