Thread: Pivot Table?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tarig Tarig is offline
external usenet poster
 
Posts: 29
Default Pivot Table?

I have exported all my monthly invoice details into excel where it shows
different products and different selling prices per unit for each invoice.
This report is relatively huge and I would like a summary that shows there
were 300 invoices for product X at selling price of $ 10, and 400 invoices
for the same product at selling price of $ 9...etc.
Is there any way that I can use Pivot Table or anything else to get my
desired summary report?

Thanks in advance

--
tarig