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:
|