Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)))
Another options:
Concat(DISTINCT {<Country = {"=Sum({<[Control Description], Country, [Fiscal Year Month]={'2016-11'}>} [Record Count]) > 300"}>} Country, ', ')
Figured it out
=Concat(
if(
aggr(
sum({< [Control Description], Country ,[Fiscal Year Month]={'2016-11'} >} [Record Count]),
Country)>300,
Country),', ')
Another options:
Concat(DISTINCT {<Country = {"=Sum({<[Control Description], Country, [Fiscal Year Month]={'2016-11'}>} [Record Count]) > 300"}>} Country, ', ')