| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002 - Pivot Table : Can I divide instead of sum ?
Dear Sir,
I have constructed a Pivot Table by the default setting using the following raw data : Pivot Table A B C D Sum of Amount Column Labels Row Labels Fuel Mileage Grand Total AA236 15000 31500 46500 BB124 17500 39800 57300 BP147 16000 37000 53000 BX411 8500 21000 29500 LK858 40600 12500 53100 NN217 17500 43000 60500 PP633 28500 32000 60500 TX441 18500 39300 57800 YR654 20000 47000 67000 G. Total 182100 303100 485200 Raw Data Fuel/Mileage Truck Amount Fuel (Litre) AA236 1000.00 Mileage (Km) AA236 2000 Fuel (Litre) AA236 3000 Mileage (Km) AA236 6000 Fuel (Litre) AA236 6000 Mileage (Km) AA236 12500 Fuel (Litre) AA236 5000 Mileage (Km) AA236 11000 Fuel (Litre) BB124 4500 Mileage (Km) BB124 9800 Fuel (Litre) BB124 3500 Mileage (Km) BB124 8000 Fuel (Litre) BB124 4500 Mileage (Km) BB124 10000 Fuel (Litre) BB124 5000 Mileage (Km) BB124 12000 Fuel (Litre) BX411 3000 Mileage (Km) BX411 7000 .......... Column D of the Pivot Table was intended for getting the fuel consumption of each truck i.e. Mileage / Fuel (Litre) or Column C divide by Column B. Is there anyway to set the pivot table to calculate this automatically at column D ? Thanks Low -- A36B58K641 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002 - Pivot Table : Can I divide instead of sum ?
Hi
From the PT toolbar dropdown, select FormulasCalculated FieldName Consumption In the Fields Pane, highlight Mileage and press Insert, then enter a / after the filed name then highlight Fuel and press Insert. In the formula bar you should see something like ='Mileage ' / 'Fuel ' Click OK -- Regards Roger Govier "Mr. Low" wrote in message ... Dear Sir, I have constructed a Pivot Table by the default setting using the following raw data : Pivot Table A B C D Sum of Amount Column Labels Row Labels Fuel Mileage Grand Total AA236 15000 31500 46500 BB124 17500 39800 57300 BP147 16000 37000 53000 BX411 8500 21000 29500 LK858 40600 12500 53100 NN217 17500 43000 60500 PP633 28500 32000 60500 TX441 18500 39300 57800 YR654 20000 47000 67000 G. Total 182100 303100 485200 Raw Data Fuel/Mileage Truck Amount Fuel (Litre) AA236 1000.00 Mileage (Km) AA236 2000 Fuel (Litre) AA236 3000 Mileage (Km) AA236 6000 Fuel (Litre) AA236 6000 Mileage (Km) AA236 12500 Fuel (Litre) AA236 5000 Mileage (Km) AA236 11000 Fuel (Litre) BB124 4500 Mileage (Km) BB124 9800 Fuel (Litre) BB124 3500 Mileage (Km) BB124 8000 Fuel (Litre) BB124 4500 Mileage (Km) BB124 10000 Fuel (Litre) BB124 5000 Mileage (Km) BB124 12000 Fuel (Litre) BX411 3000 Mileage (Km) BX411 7000 .......... Column D of the Pivot Table was intended for getting the fuel consumption of each truck i.e. Mileage / Fuel (Litre) or Column C divide by Column B. Is there anyway to set the pivot table to calculate this automatically at column D ? Thanks Low -- A36B58K641 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002 - Pivot Table : Can I divide instead of sum ?
Hello Roger,
I could not find the "Mileage" and "Fuel" fields in the dialog box. The Mileage and Fuel was under same the field of "Mileage / Fuel " as both headings were in coulmn A ("Mileage/ Fuel")of the raw data May I know is it possible to get the fuel consumption other than entering the raw Fuel and Mileage data for each truck side by side , rerun the pivot table and carry out your procedures ? Thanks Low -- A36B58K641 "Mr. Low" wrote: Dear Sir, I have constructed a Pivot Table by the default setting using the following raw data : Pivot Table A B C D Sum of Amount Column Labels Row Labels Fuel Mileage Grand Total AA236 15000 31500 46500 BB124 17500 39800 57300 BP147 16000 37000 53000 BX411 8500 21000 29500 LK858 40600 12500 53100 NN217 17500 43000 60500 PP633 28500 32000 60500 TX441 18500 39300 57800 YR654 20000 47000 67000 G. Total 182100 303100 485200 Raw Data Fuel/Mileage Truck Amount Fuel (Litre) AA236 1000.00 Mileage (Km) AA236 2000 Fuel (Litre) AA236 3000 Mileage (Km) AA236 6000 Fuel (Litre) AA236 6000 Mileage (Km) AA236 12500 Fuel (Litre) AA236 5000 Mileage (Km) AA236 11000 Fuel (Litre) BB124 4500 Mileage (Km) BB124 9800 Fuel (Litre) BB124 3500 Mileage (Km) BB124 8000 Fuel (Litre) BB124 4500 Mileage (Km) BB124 10000 Fuel (Litre) BB124 5000 Mileage (Km) BB124 12000 Fuel (Litre) BX411 3000 Mileage (Km) BX411 7000 .......... Column D of the Pivot Table was intended for getting the fuel consumption of each truck i.e. Mileage / Fuel (Litre) or Column C divide by Column B. Is there anyway to set the pivot table to calculate this automatically at column D ? Thanks Low -- A36B58K641 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot table error when Opening an Xml Spreadsheet from MS excel Xp | Charts and Charting in Excel | |||
| Moving an Excel pivot table to access | Excel Worksheet Functions | |||
| Specifying table in Excel 2002 web queries | Excel Discussion (Misc queries) | |||
| OLAP Pivot table - How to show items with no data ? | Excel Worksheet Functions | |||
| Pivot Table Enhancements/Fixes in Excel 2003 | Excel Discussion (Misc queries) | |||
Linear Mode
