Skip to Content
Feb 22, 2021 at 04:19 PM

Variable to list objects that have been filtered OUT


Standard procedure for the data analysts at our company is to include a page of report/query definitions, so the Business Users can see how the data pulled. For any filters in use (via Input Control), the definitions include a list of the data that has NOT been filtered out. In the case where there are MANY objects, the size of the list gets obnoxious and is not very helpful. Can anyone suggest a variable that will list the items that have been EXCLUDED, rather than listing the items that have been INCLUDED? I'm fairly new to BO, so any assistance would be really appreciated!