3 Replies Latest reply on Sep 17, 2017 11:20 PM by Peter Fakan

    Creating segments/groups based on above/below median

    James Gan

      I am in need of some assistance. I am trying to work out a way of isolating a group of IDs based on whether they are above or below the median value as I am then hoping to be able to profile these individuals. The only way I could think of is by manually filtering it for each age band (e.g. have one worksheet for <55 and then filter the value either being above/below $42,053) but I am hoping there is a more automated way of approaching this.

       

      Thanks in advance.

       

      James