pivot table

  • Thread starter Thread starter valerie
  • Start date Start date
V

valerie

How to I create a pivot table based on this?

Singapore Malaysia
Lipstick Sum of Manufacturer’s cost
Cleanser Average Agent’s cost
Toner
Lipstick
Cleanser
Toner

The help built in to excel wasnt helpful; I couldnt understand it
Any help given would be appreciated.
 
Can't quite see the real structure of the data from your note. I may just be blind, but it could
be wordwrap. Pivot tables need the data to be in database format, although there are ways round
this if in fact it is in a summary tabular format. Take a look at the following links to give you
an idea of how it should be, and if you have a problem then post back with more details and maybe
we can help sort your data ready for inclusion within a Pivot.

Debra Dalgleish's pictures at Jon Peltier's site:
http://www.geocities.com/jonpeltier/Excel/Pivots/pivottables.htm
And Debra's own site:
http://www.contextures.com/xlPivot01.html

John Walkenbach also has some at:
http://j-walk.com/ss/excel/files/general.htm
(look for Tony Gwynn's Hit Database)

Chip Pearson keeps Harald Staff's notes at:
http://www.cpearson.com/excel/pivots.htm

MS has some at (xl2000 and xl2002):
http://office.microsoft.com/downloads/2000/XCrtPiv.aspx
http://office.microsoft.com/assistance/2002/articles/xlconPT101.aspx


If the data is indeed in a summary tabular format, then the following link to John Walkenbach's
site will help get round that:-

Creating a database table from a summary table
http://j-walk.com/ss/excel/usertips/tip068.htm
 
Back
Top