Thread: Pivot table help for excel 2003
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
rishi rishi is offline
external usenet poster
  
Posts: 14
Default 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?
Reply With QuoteReply With Quote