0 Replies Latest reply on Aug 5, 2013 4:52 PM by Joe Howell

    Trying to filter by Top "N" of two subsets within one dimension.

    Joe Howell

      I am trying to filter down to the Top "N" based on a sales measure, but I want to show the top ranked of each subset within a specific dimension. 

      I have a dimension for different chains and I want to filter my map view to only show the top 5 stores for EACH chain.

      Chain StoreSales
      Xa15
      Xb35
      Xc59
      Xd57
      Xe54
      Xf85
      Xg96
      Xh87
      Xi13
      Xj42
      Ya5
      Yb6
      Yc7
      Yd45
      Ye21
      Yf84
      Yg823
      Yh15
      Yi22
      Yj77

      For instance, I would want to show the top 5 stores based on sales for Chain X AND Chain Y respectively, not the top 5 between the two of them.