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