I am trying to use a calculated field in a pivot table, but cannot seem to get the result I am seeking. The table consists of the count of the NCRs, the sum of the stages, and I wish to calculate the ratio of the two items.

Can it be done, or is it impossible to use a counted value in a calculated field?



Source (All)
E&P Company (All)
NCR Yes

Values
YEAR MONTH Count of NCR Sum of Stages Sum of NCR/Stage
2012 1 7 79 0
2 4 48 0
5 4 28 0
6 6 72 0
Grand Total 21 227 0