Aggregation

[bobbydave]

aggr(sum({< [Control Description], Country ,[Fiscal Year Month]={'2016-11'} >} [Record Count]), Country)) < 300

Control     Country      Record Count

X                 UK             365

Y                 USA           271

Z                France        371

Am I right in assuming that my result would be France and UK?

=IF(

aggr(sum({< [Control Description], Country ,[Fiscal Year Month]={'2016-11'} >} [Record Count]), Country)) < 300

Concat(Country, ' is greater than 300' & chr(13)),

   Concat(Country, ' is less than 300' & chr(13)))

[bobbydave]

Figured it out

=Concat(

if(

aggr(

  sum({< [Control Description], Country ,[Fiscal Year Month]={'2016-11'} >} [Record Count]),

   Country)>300,

     Country),', ')

[sunny_talwar · Accepted solution]

Another options:

Concat(DISTINCT {<Country = {"=Sum({<[Control Description], Country, [Fiscal Year Month]={'2016-11'}>} [Record Count]) > 300"}>} Country, ', ')