4 Replies Latest reply: Apr 5, 2012 12:30 PM by Jason Michaelides RSS

    Median Example Required

      Hi all

       

      I have a table with rows (12 Rows) Apr 2010, May 2010, Jun 2010 ... (And so on for 12 Financial Months)

       

      Each row has a total count of =Sum(ActivityCount) for that Financial Year Month

       

      What Im after if the median for each month (The median is based on the previous 12 months from the month as shown in the table row)

       

      Has anyone got any examples that would be helpfull

       

      Thanks

       

      MArtin