Pivot Table?

T

Tarig

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
 
S

ShaneDevenshire

Hi,

The answer to your question is Yes, a pivot table should be able to do this.
Put the Product field in the Row area, the Price field in the Row area and
the Product field in the Data area.

We could be more specific if we saw a sample of the data. By the way when
you say the count of the $10 selling price for product X, does this mean
$10.00 or does it mean 10.00 to 10.99 or 10 to 19 or something else?
 

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

Similar Threads

pivot tables 1
A slightly complicated finance problem 1
Pivot Table Formula not multiplying correctly 2
Pivot table formatting - colors 3
Pivot table 1
Calculated Item causes undue repitition in pivot table 2
Pivot Table Set Up 2
How do I replace/select new fields in pivot table using a macro? 1

Top