Page 9 of 13PREVNEXT

PivotTable I: Get started with PivotTable reports in Excel 2007

Click Play to see how to pivot a report.

Though the PivotTable report has answered your questions, it takes a little work to read the entire report; you have to scroll down the page to see all the data.

You can pivot the report to get a different view. To do that, you move a field from the Row Labels area to the column area of the report (called Column Labels), which is an area of the layout you haven't used before. When you pivot a report, you transpose the vertical or horizontal view of a field, moving rows to the column area or moving columns to the row area. It's easy to do.

To pivot this report, right-click one of the "Qtr" rows, point to Move, and then click Move "Order Date" to Columns. This will move the entire Order Date field from the Row Label area to the Column Label area of the report.

Now the names of the salespeople are all together, and it says Column Labels above the first quarter of the sales data, which is now laid out in columns across the report. Also, the grand totals for each quarter are at the bottom of each column. Instead of scrolling down the page to see the data, you can see it all at a glance.

If you want to pivot the report back to the original view, right-click one of the "Qtr" headings, and then select Move "Order Date" to Rows. That will move the Order Date field back to the row area of the report.

Click Play to see how to pivot a report.

Page 9 of 13PREVNEXT