List Box's Gray values disappear

[#1]

Hi,

I am using an expression to create a List Box object. The expression is :

If( aggr( sum(SalesAmount), CalendarYear) > 0, CalendarYear).

It shows 5 values - 2010, 2011, 2012, 2013, 2014

The problem is whenever I select any value from this object, only selected value remains in the list Box while the rest of the values disappear from the List Box object.

How can I show all the excluded values too in Listbox?

Please find the attached screenshot.

Thanks

[sunny_talwar]

May be try this:

Aggr(If(Sum({<CalendarYear>}SalesAmount) > 0, CalendarYear), CalendarYear)

[#3]

Sorry its not working

[sunny_talwar · Accepted solution]

This should work

=Aggr(If(Sum({<CalendarYear>}SalesAmount) > 0, Only({<CalendarYear>}CalendarYear)), CalendarYear)

Update: Sample attached

[Anonymous]

Is the Hide Excluded from Properties - General Unchecked?

[#6]

Awesome!

[Anonymous]

Hi Abhishek,

Please check if you have unchecked the Hide excluded in listbox properties.