Categorize Dimensions based on Expression Values

[sonu8072]

Hi Friends!

I have a district wise, date wise database for 2 organizations based on which I wish to create a list box for 'Relevant' & 'Non-Relevant' districts; 'Relevant' being the ones with SALES > 150. Sample data is as below -

COMPANY	DISTRICT	DATE	SALES
X	A	05/07/18	80
X	A	04/07/18	30
X	A	03/07/18	60
X	B	02/07/18	70
X	B	01/07/18	20
X	B	30/06/18	100
X	C	29/06/18	40
X	C	28/06/18	30
X	C	27/06/18	80
Y	A	05/07/18	40
Y	A	04/07/18	30
Y	A	03/07/18	100
Y	B	02/07/18	10
Y	B	01/07/18	70
Y	B	30/06/18	40
Y	C	29/06/18	20
Y	C	28/06/18	70
Y	C	27/06/18	70

Appreciate the help guys!

Thanks,

Aditya

[tresesco]

Try list box expression, like:

=If(Aggr(Sum(SALES), DISTRICT)>150, 'Relevant', 'Non-Relevant')

[fvelascog72]

Hi,

Try attached file

Saludos

[sonu8072]

Thanks Tresesco for the ultra fast reply! Worked like a charm.........

[sonu8072]

Hi Federico! I think the attachment is missed...

[fvelascog72]

Try now