1 Reply Latest reply on Oct 12, 2016 9:20 AM by David Li

    Percentile ranking that doesnt change with filter

    tommy durant

      So, my data is structed with two heiarchies.

       

      1.  Business unit, product

       

      2. Parent company, Individual store.

       

      NEED: I have a heat map similar to below.  But i want the heat map to be colored in 4 colors.  $0 spend, bottom 33%, mid 33%, top 33%.

       

      Issues: I want to have it where you can filter by parent , expand the heiarchy to its individual stores, so you are only seeing those parent companies individual stores.  but i still need my coloring to have the percentiles show how the indivial stores compare overall, not just within that parent company. i cant get this to work.