1 Reply Latest reply on Jan 25, 2013 1:56 AM by Robin Kennedy

    I need to identify if average of sub category  is above or below the main category average. How to avoid average of averages?

    Phani Vemuri

      Hi,

       

      I have a dataset in the format below with many rows. I need to list both program level average and department level average in a table grouped by Year and Term.

       

      I also need to highlight departments where a departments average is below program average. I used Window_Avg but it does an average of average. How do I avoid this?

       

       

      Year
      Term
      Program
      Department
      Average
      2011 / 2012Term 1P1D13.4
      2012/2013Term 1P2D14.3
      2011/2012Term 2P3D15
      2011/2012Term 1P1D23

       

       

      Thanks for your help.