6 Replies Latest reply on Apr 29, 2015 3:10 PM by Trevor Reece

    Filtering by Top Quartile

    Trevor Reece

      In the Top Quartile tab, I want to be able to filter the graph to include just companies that fall within the top quartile of spend.  So if you look at the 75th Percentile tab, just the 8 MasterCompanies highlighted in blue. 

       

      To do this, I tried to put the Top Quartile Determination measure into the Filters shelf of the Top Quartile tab, then go into the filter and only check the Top Quartile box, then hit Ok.  When I do this though, I see it is only displaying the top quartile of the MCC's on the page, and not the average spend on each MCC by the companies that make up the top quartile of spend.  Do you know a way to fix this?

       

      Thanks!