Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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)
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
Hi,
Try this
=sum({<ListBoxField ={'*'}-{'$(=GetFieldSelections(ListBoxField ))'}>} Sales)
Hi,
Try like this
=If(GetSelectedCount(ListBoxField) > 0,
Sum({<ListBoxField = e(ListBoxField)>}Sales),
sum(Sales))
Hope this helps you.
Regards,
Jagan.