4 Replies Latest reply: Feb 24, 2011 7:32 PM by Naomi James RSS

    Calculating median on an aggregate value

    Naomi James

      I have a data set that includes sales by sales rep. I need to find out what the median sale total is by rep. Whenever I use the median equation it gives me the median sale value, not the median sale value by rep. Can someone help me with this. I am sure it is something simple that I am missing.

      Thanks

      Naomi