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
|