Building a PivotTable Report – Part Two

In this tutorial, we will learn how to add multiple row labels, collapse and expand, drill down to data, sort, and refresh a PivotTable report.

Questions

• How do I add multiple row labels to a PivotTable report?
• How do I collapse and expand a PivotTable report?
• How do I drill down to data in a PivotTable report?
• How do I sort data in a PivotTable report?
• How do I refresh a PivotTable report?

Answers

• To add multiple row labels to a PivotTable report, drag the fields you want to use as row labels to the Row Labels zone.
• To collapse and expand a PivotTable report, click the plus (+) or minus (-) sign next to the row label you want to collapse or expand.
• To drill down to data in a PivotTable report, click the arrow next to the field you want to drill down on.
• To sort data in a PivotTable report, click the column header you want to sort by and then click the Sort Ascending or Sort Descending button.
• To refresh a PivotTable report, click the Refresh button on the PivotTable toolbar.