0 Replies Latest reply on Oct 25, 2011 11:58 AM by Amy Boyack

    Show Calculated Field only on Grand Total

    Amy Boyack

      Hi,

      Is it possible to show a % of total and average of months only in the Grand Total panel?  For example, I have months as columns across the top, and locations as rows.  The measure is visit count.  Then I have the grand total of all months off to the right.  I'd like to calculate % of total as well as the average month and show these ONLY in the grand total panel...not in each month.  Is there a way to do this?  I've created the calculated fields, but they are showing up in each month.