3 Replies Latest reply on Sep 24, 2013 11:22 AM by Manon V

    Average of a sum

    Manon V

      Attached is a mock-up of something I'm working on.

       

      I want to see the average of HIRES for all three years, per CPNT_EN.   The average could be at the end where the grand total is or as a column value, as long as I see it.  For some reason, any of my calculated fields give me the average per DEPT_EN.  

       

      For example, for Component A, the average should be 10.3 but I'm showing 5.

       

      Thank you for your assistance.