View Single Post
  #1   Report Post  
PSKelligan
 
Posts: n/a
Default 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