10 Replies Latest reply on Oct 17, 2018 6:28 PM by Deepak Rai

    Calculate average of list in a crosstab

    Lisa Geller

      Hello all,


      I am trying to calculate the average of a column of numbers in a crosstab I have made.  Here is a screenshot of my crosstab:




      I am able to total up each column and have placed the column total on top of each column; however I cannot figure out how to find the average (I would also like to find the medi


      I thought the calculation:


      WINDOW_AVG(SUM[admitted LOS])


      would work but it returns the value 59 all the way down the column, which is clearly not correct.  I can see that this calculation is calculating moving across the table and I need it to mve down the column but I cannot seem to figure out how to do that.







      Thanks for any help - as always,