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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivot table that will show the kilometers/liter
I sent you a sample to look at with mock data, let me know if that works or
if you need any other help -- Thanks for your help - Joe Mac "rk 5959 at gmail.com" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivot table that will show the kilometers/liter
Sorry Joe
That is where I am already, what I need is one coloum where it shows Kilometers/Liter for this I need to find the diffrence between any given odometer reading and the preveious odometer reading and divide the distance by the sum of fuel in liters for that period. unfortunately I am unable to find the diffrence between one Odometer reading and preveious reading when I tried that in the pivot table pivottable field Options Show Data as Diffrence From Base field Odometer base Previous this results in N/A all over the place in the piviot table. Thanks for the Help regards Ravi k Joe Mac wrote: I sent you a sample to look at with mock data, let me know if that works or if you need any other help -- Thanks for your help - Joe Mac "rk 5959 at gmail.com" wrote: |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivot table that will show the kilometers/liter
Some people call me anal for doing this, but I have a personal spreadsheet
that appears to track what you want... I manage the calculation external to the Pivot table but am still able to measure the variables... I'll forward it to you for your review... -- Thanks for your help - Joe Mac "rk 5959 at gmail.com" wrote: Sorry Joe That is where I am already, what I need is one coloum where it shows Kilometers/Liter for this I need to find the diffrence between any given odometer reading and the preveious odometer reading and divide the distance by the sum of fuel in liters for that period. unfortunately I am unable to find the diffrence between one Odometer reading and preveious reading when I tried that in the pivot table pivottable field Options Show Data as Diffrence From Base field Odometer base Previous this results in N/A all over the place in the piviot table. Thanks for the Help regards Ravi k Joe Mac wrote: I sent you a sample to look at with mock data, let me know if that works or if you need any other help -- Thanks for your help - Joe Mac "rk 5959 at gmail.com" wrote: |
Reply |
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 |