Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivot table that will show the kilometers/liter
HI
I have a table for keeping track of fuel expenses of each vehicle in office. the table hasthe following headders A B C D E F G H Sl No: Car No Date Expense Credit Remaining Fuel Type Liters Odometer I tried to create a Pivot table where the Car No and Date are in the row area, fuel type in coloum area and Sum of liters and sum of expense in Data area. what I want to do is to add a coloum to the pivot table that will show the kilometers/liter for each vehicle. please help. TIA regards Ravi K |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to show month end balances in a Pivot Table | Excel Discussion (Misc queries) | |||
How can I show all field data in a pivot table, instead of blank | Excel Discussion (Misc queries) | |||
Pivot Table - show items with no data | Excel Discussion (Misc queries) | |||
Pivot Table Problems | Excel Discussion (Misc queries) | |||
Problem with Pivot Table Drop-Down Menus | Excel Worksheet Functions |