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

Calculate Margins 3
pivot tables 1
Pivot Table Multiple Summary functions 0
Pivot Table Multiple functions at summary 0
Pivot Table Formula not multiplying correctly 2
Link a file to a Pivot Table in another file 0
Using 'The count of' column in a pivot table formula 0
A slightly complicated finance problem 1

Top