3 Replies Latest reply: Nov 28, 2016 11:32 AM by Sunny Talwar RSS

    Average across months in a pivot table

    Sarah Rose

      Hi,

       

      I'm trying to show an average activity figure across YTD months either replacing the total that you get from a partial sum or as well as (see excel example below)

       

      LocationApr-16May-16Jun-16Jul-16Aug-16Sep-16Oct-16TotalAverage
      Site A252320811491415021
      Site B89819479106159125733105
      Site C919711011513711586751107
      Site D8181281812159113

       

      I've read a fair amount that suggests you can do this at row total level, but haven't yet worked out how to do this at column level, if it is indeed possible.

       

      Sorry if this has been discussed elsewhere, I've not been able to find the answer I need yet!