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

    Show clients with more than 5 houses

    Mario Centeno


      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))