# Filters using common columns

Columns that are shared across multiple Business Views are distinctly marked with a Venn diagram for easy identification.

<figure><img src="https://content.gitbook.com/content/z4Tm2IzKyAiWUWiskgq5/blobs/91MaSQ84H0ZLY2t5eaTH/image.png" alt="" width="375"><figcaption><p>Indicating the common columns</p></figcaption></figure>

If you select any of the common columns that exist in multiple Business Views, then the filter will be applied to all the charts created from those Business Views. With this ability, you can intersect disparate Business Views without necessarily joining them.

1. Consider a Vizpad created with multiple Business Views - *Sales, Marketing,* and *Support*.
2. If you filter using a common column (e.g., *<mark style="color:red;">"revenue"</mark>*) from a Business View (e.g., *Sales*), then the filter will be applied to all the corresponding charts (whose Business View has a column named *<mark style="color:red;">"revenue"</mark>*).

{% hint style="success" %}
If only two Business Views (*Sales* and *Marketing*) have a column named *<mark style="color:red;">"revenue"</mark>*, then the filter will be applied to charts created using *Sales* and *Marketing*.
{% endhint %}

3. The charts that were created using Business Views other than the *Sales* Business View, will have an additional circle of color (representing *Sales*) in their chart.

{% hint style="success" %}

* The chart from *Sales* Business View will have one circle of color (indicating *Sales*).
* The chart from *Marketing* Business View will have two circles of color (indicating *Sales* and *Marketing*).
* The chart from *Support* Business View will have one circle of color (indicating Support, since it doesn’t have a column named *<mark style="color:red;">"revenue"</mark>*).
  {% endhint %}

3. The charts with more than one circle of color indicate that more than one Business View has been involved.
4. Different charts with the same circles of color indicate that those charts were created using the same Business View.

<figure><img src="https://content.gitbook.com/content/z4Tm2IzKyAiWUWiskgq5/blobs/BDBmCjQEyxtpNp2O3ixn/common-filter-mbv.gif" alt=""><figcaption><p>Applying filters using common columns</p></figcaption></figure>

If you create a chart using a Business View (e.g., "*Customer Success*") that shares a common column (like <mark style="color:red;">"</mark>*<mark style="color:red;">revenue"</mark>*) for which a filter has already been applied, the chart will automatically use that *<mark style="color:red;">"revenue"</mark>* filter. This ensures your data remains consistent, and filters get reflected with newly created charts across different Business Views.

Thus, you can select a chart created using any Business View and apply a filter using the common columns from a different Business View.