averages in pivot tables

[stephme55]

I have this column called renewal rates. It's based off renewals divided by sales (for example, 10 sales, 6 renewals = 60% rate). The rate is it's own column in my data set. So is the sales and renewals count. When I pivot table on renewals column, I have to select the average. This works fine at the channel by county level (lowest level of detail) but when I go higher up (let's say county overall) the renewal rates are incorrect because it averages the absolute %'s instead of a sumproduct. How can I fix this?

[stephme55]

I ended up just creating another calculated field in the pivot table, but still wondering if there is a way to get the true average without doing this. Thanks.