S
Scott V
My question is as follows...
In my pivot table i am trying to calculate the amount of
time a certain task is going to take. This is calculated
by taking the Gross Labor Cost divided by the Day Cost.
Both of these are included in the pivot table and pivot
table range. When i apply a new calculated field using
that formula i receive the average vs. the sum. Where you
can usually select the AVERAGE, SUM, etc. these are all
grayed out and not usable. Is there something wrong with
my formula...
='gross labor'/'day cost'
Again both of these are fields in the pivot table. Any
suggestions would be most appreciated.
Thanks,
Scott
In my pivot table i am trying to calculate the amount of
time a certain task is going to take. This is calculated
by taking the Gross Labor Cost divided by the Day Cost.
Both of these are included in the pivot table and pivot
table range. When i apply a new calculated field using
that formula i receive the average vs. the sum. Where you
can usually select the AVERAGE, SUM, etc. these are all
grayed out and not usable. Is there something wrong with
my formula...
='gross labor'/'day cost'
Again both of these are fields in the pivot table. Any
suggestions would be most appreciated.
Thanks,
Scott