Create a pivot table in excel 2003

's Computer Specifications

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?

's Computer Specifications

drag sumquantity to the right of sumprice in the column area

"rishi" <(E-Mail Removed)> wrote in message
news:ba0e24d1-ab2b-4714-a87c-(E-Mail Removed)...
> 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?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Using .Net to create Excel Pivot table	Gary Dunne	Microsoft VB .NET	3	22nd Feb 2010 07:23 PM
Excel 2007 - Create Pivot table from another pivot table	=?Utf-8?B?VG9tIEJlcmdtYW4=?=	Microsoft Excel Discussion	5	17th Nov 2007 12:51 AM
Pivot Table - Create new file with ONLY certain data - Excel 2003	=?Utf-8?B?ZW5uYTQ5?=	Microsoft Excel Worksheet Functions	1	21st Jul 2007 05:00 AM
how to create pivot table from existing pivot table in excel 2007	=?Utf-8?B?VWRheXJhaiBEaHVsZWthcg==?=	Microsoft Excel Misc	1	15th Dec 2006 04:23 AM
Can links between Excel 2003 Pivot Charts and their pivot table b.	=?Utf-8?B?TWFyayBBbGxlbg==?=	Microsoft Excel Charting	2	5th Mar 2005 05:24 PM