2 Replies Latest reply: Oct 9, 2013 1:21 PM by matthew thompson RSS

    Populate column rows with column Total

      Hi,

       

      I'm working with a pivot table and need to populate the every row in a column with the columns sum. I've tried using the TOTAL function, but this totals across all dimensions in the pivot table. I've tried aggregating by my dimension of interest, and although this works, the total's only shown at the top of the table, not in each cell of the column.

       

      I've attached an app to better illustrate the issue.

       

      Any advice would be great.

       

      Thanks,

       

      Matt