PivotTable report layout Lay out the report onscreen 1. From the PivotTable Field List window, drag the fields with data that you want to display in rows to the drop area labeled Drop Row Fields Here. If you don't see the field list, click within the outlines of the PivotTable drop areas, and make sure Show Field List is pressed in. To see what levels of detail are available in fields that have levels, the click next to the field. 2. Drag fields with data that you want to display across columns to the drop area labeled Drop Column Fields Here. 3. Drag fields that contain the data that you want to summarize to the area labeled Drop Data Items Here. Only fields that have the or icon can be dragged to this area. If you add more than one data field, arrange these fields in the order you want: Right-click a data field, point to Order on the shortcut menu, and use the commands on the Order menu to move the field. 4. Drag fields that you want to use as page fields to the area labeled Drop Page Fields Here. 5. To rearrange fields, drag them from one area to another. To remove a field, drag it out of the PivotTable report. To hide the drop area outlines, click a cell outside the PivotTable report. Note If data is very slow to appear as you lay out the report, click Always Display Items on the PivotTable toolbar to turn off initial data display. If retrieval is still very slow or error messages appear, click PivotTable and PivotChart Report on the Data menu, and lay out the report in the wizard. Lay out the report in the wizard If you've exited from the wizard, click PivotTable and PivotChart Report on the Data menu to return to it. 6. In step 3 of the wizard, click Layout. 7. From the group of field buttons on the right, drag the fields that you want onto the ROW and COLUMN areas in the diagram. 8. Drag the fields that contain the data that you want to summarize onto the DATA area. 9. Drag fields that you want to use as page fields onto the PAGE area. If you want Excel to retrieve data one page at a time, so you can work with large amounts of source data, double-click the page field, click Advanced, click Query external data source as you select each page field item, and then click OK twice. (This option is unavailable for some types of source data, including OLAP databases and Office Data Connections.) 10. To rearrange fields, drag them from one area to another. Some fields can only be used in some of the areas; if you drop a field in an area where it can't be used, the field won't appear in the area. 11. To remove a field, drag it out of the diagram. 12. When you are satisfied with the layout, click OK, and then click Finish.
Pages to are hidden for
"PivotTable report layout"Please download to view full document