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