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

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

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:

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: