Friends,

I created a simple pivot table that is pulling values from four table
columns (LineOf Business, WeekEndDate, Salesmen_HeadCount, Salesmen_Quit). In
the pivot table, the aggregate function for Salesmen_HeadCount is Average()
and the aggregate function for Salesman_Quit is Sum().

Here is my problem: I now want to add a calculated field to the pivot table
that will return the Turnover Ratio, which should always be Salesman_Quit /
Average(Salesmen_HeadCount) no matter how I am viewing the data (i.e.,
grouped by LineOfBusiness, Grand Totals, etc.). For example, if the pivot
table shows 100 for Salesmen_HeadCount (which is the Average
ofSalesmen_HeadCount) and Salesman_Quit is 50, the Turnover Ratio should =
50/100 or 0.50.

But no matter how I construct the formula for Turnover Ratio calculated
field, the answer is wrong.

Anybody know how to make this work? Thanks ...

bill morgan