R
rk 5959 at gmail.com
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
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