Help with pivot table


A

Alessandro

Hello all,
I need an help with the pivot tables in Excel 2002.
I have a pivot table (with all the data extracted by a single sheet) with
the data about the articles that the firm where I work has sold.
For each article there is the amount in quantity and in euros.
When I put this in a pivot table, I get 2 rows for each article.
A row with the quantity amount and a row with the euros amount.
I don't like this. I want one only row per article, with 2 columns on the
right side of the table, a column with quantity amount and a column with
euros amount.
Is this possible to do it with a pivot table? In which way? I'm trying but
I'm not able.
And, if it's not possible, there are other instruments similar to pivot
tables in Excel to do what i want?
Thank you :)

Alessandro
 
Ad

Advertisements

H

HKaplan

If I understand what you want to accomplish, do this:

Your current Pivot Table should have a gray "data" box in the top
row. Drag it to the right one cell. That will convert your 2 rows
per record to one row with the 3 columns you want.
 
Ad

Advertisements

A

Alessandro

Yes, this is exactly what I was looking for. Thank you for your help.
These are my first steps with pivot tables, so not everything is immediate :)
 

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

Top