RE: Pivot Table
Hi Krista,
A PivotTable report is an interactive table that quickly combines and compares large amounts of data. You can rotate its rows and columns to see different summaries of the source data, and you can display the details for areas of interest.
Use a PivotTable report when you want to analyze related totals, especially when you have a long list of figures to sum and you want to compare several facts about each figure.
An example would be looking into a sales report, broken down by Region, Product, Sales Person or Quarterly Totals. You are able to expand and contract the detail of each area to focus on the detail that is most important to you.
To create a Pivot Table from this list you must first select a cell from within the list, go to the Menu command, Data and Select the ladder option Pivot Table and Pivot Chart Report. Follow the steps in the Wizard, when the Pivot Table blank appears, drag and drop your fields as required onto the four areas and your Pivot Table will appear.
Tracy
