1 Reply Latest reply on Feb 15, 2013 1:04 PM by Tracy Rodgers

    Grand Total row with Sums and Averages

    Brian Beisner

      When challenged with needing a grand total row to have both summed and averaged values I accomplished such using a Table Calculation.  Set the grand total to be sums then use the Window_Avg function of the summed values for the columns needing to be averages.  The attached document explains the specifics.