Pivot Table Summary to Average

I field in the pivot table which reflects an average.    The base pivot table works as expected and delivers the correct averages, HOWEVER, on the pivot summary (both rows and columns), it sums this information as opposed to the overall average.  Is it possible to change the pivot table summaries to average?

1reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Greig DeSautel Thanks for your feedback.  At this time you cannot adjust the aggregation of the column summary. However, we are aware of the problem and improvements in our pivot tables, including control of the aggregation in the summary, is scheduled for later this year.

    Like 1
Like1 Follow
  • Status Answered
  • 3 mths agoLast active
  • 1Replies
  • 21Views
  • 3 Following