12 Replies Latest reply on Nov 13, 2014 3:57 PM by KK Molugu

    How can I keep the Sub total from averaging?

    joe major

      Hi,

       

      I have two tabs in this work sheet, one is SUM(TIME) and AVG (TIME).  The first tab correctly shows the sub total WHEN I REMOVE Process Name from the Rows shelf.   BUT, on tab 2 (AVG (TIME), when I remove Process Name from the Rows shelf, the sub total averages the total.  B

       

      How can I make the sub total, total the Process names, not average them when I remove the Process Name from the Rows shelf?

       

      Thank you.