8 Replies Latest reply: Jun 20, 2011 1:13 AM by Khim Hoe Tan RSS

    Custom Total Row

      Hi all,

       

      How can I add a custom total row into a pivot table? This custom total is not the same as the total of the expression. For example, the expression I use is total count of customer, but in the total row, I want the overall total count of customer AND the total sales amount. I tried adding both into the expression, but the extra expression will repeat in the content of the table. (I only want the total, not the main table) Attached is the sample that I'm working on, and also the desired output in Excel format.