14 Replies Latest reply: Nov 22, 2015 12:08 PM by camiel van der werf RSS

    Rank top 3 with 2 dimensions

    camiel van der werf

      Hello,

       

      I want the top 3 theft of cars by 2 dimensions city and by brand of cars. So for example this is my table:

        

      city (dimension)brand car (dimension)car theft (expression)
      Groningentoyota5%
      volvo14%
      bmw18%
      Amsterdamtoyota2%
      renault7%
      mercedes9%
      Rotterdamvolkswagen31%
      citroen9%
      peugeot22%

       

      Then i want to show only rotterdam Volkswagen (31%), Rotterdam Peugeot(22%) and Groningen bmw(18%). I got already a document with the title ' show top  performers'. This document is telling about how you can rank with the formula rank and agr. I tried a lot of things with this. But i do not get it right. Does somebody know how you can do something like this?

       

      regards,

      Camiel