Pivot Table Primer


R

Rich

Hi,

I have a worksheet with product sales by branch which looks like this (very
simplified, thousands of rows of data)

Branch Product Sales Value Refund Value
town1 widget a 445 0
town2 widget a 1345 23
town3 widget a 5643 0
town1 widget b 333 0
town2 widget b 664 0
town 3 widget b 332 0


etc,


I want it to look like:-

widget a sales widget a refunds widget b sales widget b
refunds
Town 1 445 0 333
0
Town 2 1345 23 664
0
Town 3 5364 0 332
0


I "think" Pivot Tables are the solution, but not really used them, can
someone confirm this is the best way, or point out a better way, and can
anyone recommend a really good online Pivot Table primer ?
 
Ad

Advertisements

D

Dave Peterson

Some more:

Debra Dalgleish's pictures at Jon Peltier's site:
http://peltiertech.com/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
 
Ad

Advertisements

R

Rich

Dave Peterson said:
Some more:

Debra Dalgleish's pictures at Jon Peltier's site:
http://peltiertech.com/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

Thanks Ed and Dave,

Those links are great, I'm a lot further forward now.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top