ExcelBanter - Pivot table help for excel 2003

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Pivot table help for excel 2003 (https://www.excelbanter.com/excel-worksheet-functions/231443-pivot-table-help-excel-2003-a.html)

rishi

Pivot table help for 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?

Roger Govier[_3_]

Pivot table help for excel 2003

Hi

Just Grab the Data button on the PT and drag to the left and drop on Total

--
Regards
Roger Govier

"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 12:35 AM.