| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Pivot table help for excel 2003
Hi
Just Grab the Data button on the PT and drag to the left and drop on Total -- Regards Roger Govier "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 | |||
| MS Excel 2003 - pivot table | Excel Discussion (Misc queries) | |||
| Pivot Table Excel 2003 Formatting | Excel Discussion (Misc queries) | |||
| Excel 2003 Pivot Table | Excel Discussion (Misc queries) | |||
| RESTRICT PIVOT TABLE IN EXCEL 2003 | Excel Discussion (Misc queries) | |||
| Can links between Excel 2003 Pivot Charts and their pivot table b. | Charts and Charting in Excel | |||
Linear Mode
