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 median) of each column.

       

       

      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,

      Lisa