---
sourceDocument: Australia Platform Analytics
sourceDocumentLink: https://www.servicenow.com/docs/r/now-intelligence

 Release :

    - australia

ft:locale :

    - en-US

ft:publication_title :

    - Australia Platform Analytics

ft:clusterId :

    - par

bundleId :

    - par

workflow :

    - Platform


---

# Set many-to-many filters

# Set a filter to follow another filter {#ariaid-title1}

* Release version: Australia
* 
* Updated March 12, 2026
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 3 minutes to read

In some cases, values on a pair of filters can refer to multiple values on each other. For one such filter to follow another, it must go through a connecting table.

## Before you begin

Role required: admin

## About this task

In most cases, a filter follows another filter either in a one-to-one relationship or in a one-to-many relationship. In the latter case, the filter source is a reference field. Anyone who can edit a dashboard can set up one
such filter to follow another on that dashboard, in a direct connection. Users with the analytics_filter_admin role can also create such filters in the filter library. For more information, see the example in [Configure a Single/Multiple select or cascading filter](https://www.servicenow.com/docs/RLvttlx0xmUgN51EJkD4hg "Let users filter a dashboard tab on one or more values from a set of choices, such as incident priority. You can have a single or multiple select filter follow another filter in a cascade.").

If the values on each filter can refer to multiple values on the other filter (a many-to-many relationship), you have to select a connecting table. This connecting table has a unique record for every possible reference
between the two filters. The connecting tables between two tables are defined in the Collection
\[sys_collection\] and Many to Many Definition \[sys_m2m\] tables. Only
administrators can access these tables.  
Note:  
Connection tables come predefined for any relevant tables included in the base system or in Platform Analytics Solutions. However, if you want to use a custom table in a many-to-many relationship, you must define that relationship in the Many to Many Definition table. Instructions on doing so are outside the scope of this topic. For more information, see [Create a many-to-many table relationship](https://www.servicenow.com/docs/access?context=t_CreateAManyToManyRelationship&version=australia&pubname=australia-platform-administration&ft:locale=en-US).

## Procedure

1. Add at least two single or multiple select filters to the relevant dashboard.  
   For more information about adding filters to a dashboard, see [Create or add a filter on an inline dashboard](https://www.servicenow.com/docs/EgipF0if1yb5FCroSh3bHw "Create a filter or select one from the filter library. When creating a filter, name it, and choose whether to create a single select, multiple select, date, or true/false filter.").
2. Put the dashboard in Edit mode.
3. Open the configuration menu for the filter that you want to follow the other filter.  
   If the filter can follow any other filters on the dashboard in a many-to-many relationship, these filters are listed under Filters with table connection in the Other filters to follow section.  

4. Turn following on for the filters that you want this filter to follow.
5. If no connecting table has been selected for that filter, a dialog opens to select the connecting table.  
   The Table icon by the toggle is grayed out when no connecting table has been selected yet.  

   After you set the connecting table, you can select the table icon to change it.  
   If you have the choice between more than one connecting table, the names of the connecting tables should suggest which one to select. For example, Excluded Users \[sys_user_license_exclude\] filters on users who don't have a subscription whereas User Subscription \[sys_user_has_license\] filters on users who do.  

6. Save the dashboard and exit editing mode.

## Filter users by their manager {#set-filter-to-follow-filter__example_rql_wgp_xjc}

In this example, you pick an assignment group and see which incidents are assigned to each member of the group.

1. Start by creating a dashboard and adding a List of incidents.  

2. Add a single select filter on the Group \[sys_user_group\] table, with no fields specified.
3. Add another single select filter, of data on the User \[sys_user\] table with no fields specified.
4. On this filter, add under Data to filter the "Assigned to" field on the Incident \[incident\] table.  

5. Scroll down the Configuration panel to the Follow other filters section.
6. Under Filters with table connections, toggle on Follow Group and select the Group Member \[sys_user_grmember\] connecting table.
7. Save the dashboard and exit editing mode.

{#set-filter-to-follow-filter__ol_dbt_glp_xjc}

Now, when you select a group and then select a member of that group, you filter the incidents by that member.
Figure 1. Many-to-many filter in use