PivotTable report layout

Document Sample
PivotTable report layout Powered By Docstoc
					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.

				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:3
posted:3/26/2010
language:English
pages:2
Description: PivotTable report layout