Selecting values to exclude from chart

[#1]

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!

[jpenuliar · Accepted solution]

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

[#3]

Of course. Thank you!