exclude list box selection

[sat_tok52]

Hi Guru's,

I have list box have A,B,C data and also have a straight table ,as per my requirement if I select list box data A my straight should exclude A data and it should show B,C Data,it means it should exclude current selection show remaining data.

In any help.

Thanks,

Sateesh.T

[sunny_talwar · Accepted solution]

Try this as your set analysis in your expression: {<ListBoxField = e(ListBoxField)>}

For an expression Sum(Sales) you can do -> Sum({<ListBoxField = e(ListBoxField)>}Sales)

[sat_tok52]

Hi Sunny

Thanks for quick response.When I am using set analysis initially my table not showing any data after selecting data it's working fine but my table  should show all data without selecting.

Thanks ,

Sateesh

[sasikanth]

Hi,

Try this

=sum({<ListBoxField ={'*'}-{'$(=GetFieldSelections(ListBoxField ))'}>} Sales)

[jagan]

Hi,

Try like this

=If(GetSelectedCount(ListBoxField) > 0,

Sum({<ListBoxField = e(ListBoxField)>}Sales),

sum(Sales))

Hope this helps you.

Regards,

Jagan.