I want to find the average of a column in a pivot table. Essentially I want (Sum of Column values)/(Number of Rows). I know I can count the number of rows myself, but if the source data changes, the cells containing the total sum or the number of rows might change.
So my question is, how do I link my formula to a pivot table column, rather than to specific cells such that when the source data changes, my formula does not get screwed up.
Thanks!
Bookmarks