Create a dropdown to include or exclude a bunch of column values

Summary

dropdown to filter on column values

Content

Hi all,

I have a dashboard(in BI Answers) where I am looking to add a dropdown-to include or exclude a bunch of column values.

If the user picks include, I want these bunch of values(all from one column) included in the analysis. If they pick exclude, the values should be filtered out. I am able to create a calculated item(group) and include or exclude these values.

But how do I make the user pick these as an option?

Thanks.

Version

Oracle Business Intelligence 12.2.4.0.0