New user, conditional formulas

[Fateyes]

Hi,

Any help/advice would be greatly appreciated. I need to setup/design a new spreadsheet with the following information:

Customer name, customer type, customer group code, weekly sales for entire year.

The data will be added on a weekly basis, which will include the addition of new customers. Obviously there will be many columns (52 for each weeks sales, plus extras for monthly and yearly totals, plus customer info).

From the data I will want to extract and display the following information in another sheet/s:

Sales data by customer type, sales data by group (i.e restaurants owned by same company), top 10 customers, top 10 customers by type.

The thing I am having the most trouble understanding will be the conditional formulas required to display the info on a new sheet.

I have attached a small example of the main sheet.

Any advice greatly appreciated!

Fateyes

[tuph]

A pivot table will do what you want - see attached. (I had to move the headings for columns A:C into row 2 to make it work.)

[Fateyes]

thanks for the advice. Do I need to make a separate pivot table for each query that I want to make? I.e One for top 10 restaurants, one for top 10 shops, etc

[tuph]

As far as I know you will need separate pivot tables, but someone with more expertise may have more information for you.