6 Replies Latest reply: Aug 9, 2018 1:13 PM by Mario Centeno RSS

    Show clients with more than 5 houses

    Mario Centeno

      Hi


      I need to show the clients that have more than 5 houses in a table.


      In my data I have 2000 clients but only 22 have more than 5 houses, those 22 I need to show in a table.

       

      In the dimension I have the following expression


      =if( aggr((count(NAME_CLIENT)),NAME_CLIENT)>5, NAME_CLIENT,)

       

      Expression measure

      =Sum(Aggr(if(count(NAME_CLIENT) > 5, 1, 0), NAME_CLIENT))

       

      consulta.png