pivot tables

Hi Jason

Thanks for your question

The following is the best procedure

1. Select a cell in the source data
2. Go to Data Pivot Table and Pivot chart report
3. Select MS Excel List and Pivot Table at step 1, click next
4. Confirm that the wizard has selected the correct range (step 2)
5. Choose to place the pivot in an existing or new sheet(step 3)
6. You now have the pivot table design sheet. Simply drag the required fields into the table to create your required pivot table.

It is a good idea to have a clear understanding of hwta you are trying to achieve before you build your pivot table

Regards

Stephen