Pivot Tables - calculate field?
 

Hi, I was wondering if someone can help me.

I've created some pivot tables based on trying to get the average of counts
from staff on a daily basis for the week - now it's automatically averaging
staff's counts when they're not working on some of days of the week - example
they work just monday it gives an average of the whole week. What I think I
need to do is calculate a formula in the pivot table so that it gives the
correct average for each person - based on only what they have worked. But
I'm still kind of new to formulas.

What kind of formula will I need to write - is it how many hours divided by
their count that gives a sum figure of their actual average?

Any help much appreciated.

Pivot Tables - calculate field?
 

Hi

You will need to provide some more detail of what your source data looks
like.
What are the column headings, what data appears in a few sample rows.

--
Regards
Roger Govier



"JuniorPivot" <u39019@uwe wrote in message news:7b268094153d6@uwe...
Hi, I was wondering if someone can help me.

I've created some pivot tables based on trying to get the average of
counts
from staff on a daily basis for the week - now it's automatically
averaging
staff's counts when they're not working on some of days of the week -
example
they work just monday it gives an average of the whole week. What I think
I
need to do is calculate a formula in the pivot table so that it gives the
correct average for each person - based on only what they have worked. But
I'm still kind of new to formulas.

What kind of formula will I need to write - is it how many hours divided
by
their count that gives a sum figure of their actual average?

Any help much appreciated.

Pivot Tables - calculate field?
 

Hi Roger

Yep sorry about the details - but I've figured it all out lol something must
have clicked in my head when I wrote this out.Am really chuffed :)

Thanks anyways

JP

--
Message posted via http://www.officekb.com