3 Replies Latest reply: Jan 13, 2016 9:29 AM by vishal waghole RSS

    count as condition inside set

    Tomas Hylander


      I'd like to sum up customers that have more than 5 orders and lives in Sweden.

      Tried to search for a solution but couldnt find how to use Count inside a Count.

      This is what i have as of now;


      count({$<Country={'SWE'} >} DISTINCT Kundnr)


      and I would like to have something like this;

      count({$<Country={'SWE'}, Count(ordernr)>=5 >} DISTINCT Kundnr)


      Thanks in advance!