Pivot Table Advice

[fetster]

I have a customer table which shows every customer that has visited us, their postcode (e.g AB12) and the number of visits that particular customer has made.

I would like to create / filter the data so that it shows a table with the total number of visits for every customer in that particular postcode (it collates the same postcodes and the total number of visits for that postcode).

For Example Postcode AB12 has 2 customers who have each visited 2 times. Postcode AB13 has 3 customers who have each visited 3 times.
I want table to show AB12 4 , AB13 9 etc.

Would a pivot table do this? If so how?

Thanks

[Pepe Le Mokko]

Hi
Go to Insert - Pivot Table and follow the wizard - Also lots of PT tutorials on the net

[GeneralDisarray]

Can you upload an example sheet? You can do this a couple of ways. Try sliding the name to the "row labels" area, the code to the "column labels" area, and see what you think.

That will show the different postal codes horizontally, and the customers vertically. You can click on the "Column Labels" filter and select one or more to display.

[fetster]

Hi, thanks for your advise

I am getting error message ' The Pivottable Field Name is not Valid. To Create a pivot table report you must use data that is organised as a list with labeled columns. If you are changing the name of a PivotTable field, you must type a new name for the field.

I'm not entirely sure what it is saying as I don't have a Pivottable Field Name.

Any suggestions?

[GeneralDisarray]

According to Microsoft: This problem occurs when the first row of the range from which the PivotTable is attempting to pull data contains one or more empty cells.

http://support.microsoft.com/kb/213955

To resolve this problem, use either of the following methods.
Method 1: Remove Empty Cells
Modify the first row so that it does not contain any empty cells.

Method 2: Select a Cell Range with No Empty Cells in the First Row

Change the range the PivotTable references to a range where the first row does not contain empty cells. To change or determine the range of cells referenced by an existing PivotTable, follow these steps:
Select a cell within the PivotTable.
On the Data menu, click PivotTable Report and Print Chart Report.
On the PivotTable and PivotChart Wizard - Step 3 of 3 page, click Back to display the PivotTable and PivotChart Wizard - Step 2 of 3 page.
The current range for the PivotTable is displayed in the Range box. If you need to modify this range, type a new range in the Range box.
Click Finish.