3 Replies Latest reply on Oct 3, 2012 5:35 AM by sirajmandayippurath

    Adding Grand Total as Average

    Eric McDonald

      I have a matrix / pivot table showing stock name in rows and funds in columns. The metric in the middle is sum of holdings (number of shares). I can add a Grand Total to rows or columns which shows Sum of holdings of either rows or columns, but what I actually want in the Grand Total row/column is the average holding. So sum of holdings in middle section, but average of summed holdings in total row/column. How can I do this?