Can PIVOT Table do this?

[Guest]

Cross Posting as I am getting nowhere in General Questions:

I have just started to explore Pivot tables but before I go any farther I
need to check to see if what I am trying to do is in fact a correct use of
Pivot tables.
We have a product price list : Item #, Description, Qty per box, Price per
box and Qty Ordered.
We have 993 different products TODAY but it goes up & down as new stuff
arives / old stuff is sold.

Right now we email or fax a 20 page Word doc to our customers who fill in
the Qty ordered and fax it back to us.

I have copied it to Excel and added a column to calculate Order Cost = Price
Per Box x Qty Ordered.

Out of the 993 items we offer on average an order will have about 50 items.

Can a Pivot Table summaraize just what has been ordered?

if it cannot then I will not go farther in learning Pivot Tables. If yes
then I need to pursue and I will appreciate all tips & pointers

Thanks
(e-mail address removed)

 

[ScottO]

It looks like the Pivot Table will easily handle your needs.
Just select a cell within your data, choose Data/Pivot Tables and use
the wizard. It's fairly self-explanatory, but refer to in-built help
for a few extra pointers.
Rgds,
ScottO

| Cross Posting as I am getting nowhere in General Questions:
|
| I have just started to explore Pivot tables but before I go any
farther I
| need to check to see if what I am trying to do is in fact a correct
use of
| Pivot tables.
| We have a product price list : Item #, Description, Qty per box,
Price per
| box and Qty Ordered.
| We have 993 different products TODAY but it goes up & down as new
stuff
| arives / old stuff is sold.
|
| Right now we email or fax a 20 page Word doc to our customers who
fill in
| the Qty ordered and fax it back to us.
|
| I have copied it to Excel and added a column to calculate Order
Cost = Price
| Per Box x Qty Ordered.
|
| Out of the 993 items we offer on average an order will have about
50 items.
|
| Can a Pivot Table summaraize just what has been ordered?
|
| if it cannot then I will not go farther in learning Pivot Tables.
If yes
| then I need to pursue and I will appreciate all tips & pointers
|
| Thanks
| (e-mail address removed)
|