10 Replies Latest reply on Jun 15, 2018 1:22 PM by Reporting DAD

    Getting Top and Bottom 3 using 2 measures as a base

    Reporting DAD

      I have data as shown below

       

      NameRevenueSpendCR
      A5102
      B1053
      C25308
      D15504
      E35361
      F45407
      G60556
      H208010
      I707515
      J659020
      K554514
      L807011
      M40309

       

      Now I wanted the names with Top 3 revenue. I sorted and used Index to achieve the same.

       

      Now I have 2 more things to do.

      First I wanted top 3 names with highest CR, but it should be exclusive of the top 3 names with highest revenues found above with index.

       

      Second I want the top 3 names who has spend the highest but has the lowest CR.

       

      Can this be achieved?

       

      Added : The data also has some more columns why which it can be filtered. Also everyday the data will keep getting added to this. The above is just a sample. Please is the attached workbook.