| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create a pivot table in 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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Create a pivot table in excel 2003
drag sumquantity to the right of sumprice in the column area
"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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
| Excel 2003 Pivot Table Problem - Can No Longer Create Calculated Field | Excel Worksheet Functions | |||
| how do i create a table in excel 2003? | Excel Discussion (Misc queries) | |||
| Pivot Table - Create new file with ONLY certain data - Excel 2003 | Excel Worksheet Functions | |||
| Can links between Excel 2003 Pivot Charts and their pivot table b. | Charts and Charting in Excel | |||
Linear Mode
