Pivot table help for excel 2003

R

rishi

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?
 

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

Similar Threads

Create a pivot table in excel 2003 1
Dealing with a Pivot Table (when I don't want to) 0
Found few bugs in my daily routine of work in excel for MAC 0
Dates In Excel 5
Power Pivot. Yikes. 0
Found few bugs in my daily routine of work in excel for MAC 0
Doughnut Chart linked with the slicer in the pivot table 0
Excel does not accept text format! 0

Top