list box issue

[manoranjan_d]

Hi all,

I have attached the sample for the list box what i need is if i select the IT in the list and if i select the sec1 in the section list, sec4 and sec5 are hiding i need that value.

i got successful on the section available for the specific dept such that unavailable section are getting hide for the specifc dept, but the

issue is when i  select the section value in the list the other values are getting hide, so the value in the section should not hide how to acheive it

[adamdavi3s]

Well your items are hiding as the list box is using an expression rather than simply using the field name.

I can't quite see why you would do this in this situation, but the simple issue is either:

1- just use the field name

2- alter your listbox expression to this:

=AGGR(Only({1}SECTION),SECTION)

Please remember to mark this as helpful or the correct answer if I have helped you or answered your question.

[sunny_talwar · Accepted solution]

You need this?

Try this:

=AGGR(Only({<SECTION>}SECTION),SECTION)

[manoranjan_d]

Thaks

[sunny_talwar]

No problem

[manoranjan_d]

i need one more help

=aggr(only(DATE(created_date,'DD-MMM-YYYY')),created_date)

how to apply for this?

[sunny_talwar]

What are you trying to apply here? Just a pure guess here:

=Aggr(Only({<created_date>} Date(created_date,'DD-MMM-YYYY')), created_date)