List Box excluding some data

[danialier]

Hello,

I have a list box showing the months for 2013. Some of these months have revenues, but July and August have 0 revenue.

I want the list box to show all months except July and August.

How I can do that ?

thks,dani

[MK_QSL · Accepted solution]

IF(Aggr(SUM(Revenue),Month)>0,Month)

Use above in List Box Expression