Pivot Table Formula Fields

[ralphralph07]

Hello

I'm having a problem getting a formula field to work correctlty.

I have pivot table that sums by department but i want to show this as an average for the department.

Row Data:

Department
HeadCount

Data:
Month

Column:
Status

I have a row field called head count that gives me the total people by department so it should just be the sum by department/head count.

I have tried to create a formula for the pivot table as follows:

=Sum(Month)/Head Count

But this doesn't work as returns 0

If i manually set the head count in the formula this works.

But I need the head count to change depending on the department.

Any ideas?

Ralph