Pivot table help for excel 2003

  • Thread starter Thread starter rishi
  • Start date Start date
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?
 
Hi

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

Just Grab the Data button on the PT and drag to the left and drop on Total
 
You must log in or register to reply here.

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
query with duplicated data 2
Accumulated percentage calculation 2
Pivot table to calculate variance showing budget and actual. 2
Pivot Table 3
Excel 2007 Pivot Tables compatible with 2003 3
Pivot Table Percentage of Sub-Total 7
Pivot Table--Daily and MTD Total 7

Back
Top