Pivot Table Customize functions in the Data Field
Hi all,
I want to find out if it is possible to create custom formulas in the data
field of a pivot table.
I need to to show:
Fleets of vehicles.
How many of a particular fleet a particular company has on hand.
A percentage of how much of that companies fleet is not operational.
If no maintinane is completed between Now() and the end of the reporting
period, What the % of maintenance failure we will have for a fleet.
I think the best way to accomplish this is a pivot table but the built in
functions are not going to handle the calculations I need.
--
Thanks,
Patrick
|