Report Layout Options

3. Try it: Change the Report Layout

Go to PivotTable Tools ->Design.

Go to Layout-> Report Layout.

Select: Show in Outline Form.

 

What Do You See? The Report Layout options include the following:

Show in Compact Form

Show in Outline Form

Show in Tabular Form

Repeat All Item Labels

Do Not Repeat Item Labels

 

Keep going...

 

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