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

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.

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 :)

"HKaplan" wrote:

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.