Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I have a chart with sum(Amounts). Is there a way that I can create a list box or table where the user can select values that the expression will exclude/ignore?
For example, a list box with top 10 [Orders] (ranked by sum(Amounts)) that the user could select to see the effect on the chart without them.
Thanks!
You can add a Field Event Trigger at Document Property (CTRL+ALT+D),
Select the target Field in your listbox
add an "On Select" Action, Action Type : "Select Excluded", select the field you want to apply the Exclusion
You can add a Field Event Trigger at Document Property (CTRL+ALT+D),
Select the target Field in your listbox
add an "On Select" Action, Action Type : "Select Excluded", select the field you want to apply the Exclusion
Of course. Thank you!