ExcelBanter - Create a pivot table in excel 2003

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Create a pivot table in excel 2003 (https://www.excelbanter.com/excel-programming/428742-create-pivot-table-excel-2003-a.html)

rishi

Create a pivot table in excel 2003

Hi,

I need to create a pivot table in excel 2003 in the following format
-:

Item SumPrice SumQuantity
A 100 20
B 200 30

But by default the pivot table created is in the format -:

A SumPrice 100
SumQuantity 20

B SumPrice 200
SumQuantity 30

Can anyone please help on this?

Patrick Molloy

Create a pivot table in excel 2003

drag sumquantity to the right of sumprice in the column area

"rishi" wrote in message
...
Hi,

I need to create a pivot table in excel 2003 in the following format
-:

Item SumPrice SumQuantity
A 100 20
B 200 30

But by default the pivot table created is in the format -:

A SumPrice 100
SumQuantity 20

B SumPrice 200
SumQuantity 30

Can anyone please help on this?

All times are GMT +1. The time now is 02:27 PM.