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

PS,
Don't know what numbers you're working with but in a pivot table, you can
drag down the same number several times and have it sum, count, average, maxm
min, product, count numbers, etc. in the 'PivotTable Field' box (to get here,
drag a number into the data section and double-left-click on that field).
Also, did you know that in the 'PivotTable Field' box there is a button
called 'Options'. This opens a section on the bottom that says 'Show data
as:'. If you drop down the listbox (default is 'Normal'), you will see
selections for 'Difference From', '% of', '% Difference From', 'Running Total
in', '% of row', % of column', etc..
Hope this helps,
Sincerely,
Gary Brown


"PSKelligan" wrote:

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

Another issue is...
When you first create a Pivot Table with more than one field of data in it,
the data lists vertically down the table. My preference is to see this info
listed horizontally across the table. To do this, I drag the field that says
'Data' over to the 'Grand Total' column and release it.
HTH,
Gary Brown

"Gary Brown" wrote:

PS,
Don't know what numbers you're working with but in a pivot table, you can
drag down the same number several times and have it sum, count, average, maxm
min, product, count numbers, etc. in the 'PivotTable Field' box (to get here,
drag a number into the data section and double-left-click on that field).
Also, did you know that in the 'PivotTable Field' box there is a button
called 'Options'. This opens a section on the bottom that says 'Show data
as:'. If you drop down the listbox (default is 'Normal'), you will see
selections for 'Difference From', '% of', '% Difference From', 'Running Total
in', '% of row', % of column', etc..
Hope this helps,
Sincerely,
Gary Brown


"PSKelligan" wrote:

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