---
schema_version: "1"
id: 97a8df285dc276d3492f7c223e07bad8a08d39cb0952aaaf4d0e5fc95613b7ca
title: Create Slicing Filters
collection: tableau
version: current
locale: en-us
portal_url: https://docs.salesforce.com/tableau/current/en-us/pro/desktop/filtering_calculation.md
canonical_url: https://help.tableau.com/current/pro/desktop/en-us/filtering_calculation.htm
source_site: help.tableau.com
content_type: documentation
content_hash: 11672a80215f760ca07a8d11caa8a492d23735452bfa0f6afa788761c7d48b1a
description: Create slicing filters for multidimensional data sources in Tableau.
---
[Skip to main content](#main-content)

# Create Slicing Filters

Slicing filters, also known as slicers or calculation filters, are dimension filters that behave differently for multidimensional data sources than they do for relational data sources.

In Tableau, multidimensional data sources are supported only in Windows.

A slicing filter exists when:

- The dimension that you place on the Filters shelf is not also on any other shelf in the view.
- The filter is defined to include multiple values. For example:
    
    ![Calculation filter dialog with the General tab selected and the furniture and office supplies categories selected from the list of categories.](/tableau/current/en-us/pro/desktop/en-us/Img/caclfilter_1.png)

For relational data sources, there is nothing remarkable about a slicing filter. Tableau recalculates values for each measure in the view using the configured aggregations.

But because multidimensional data sources contain data that is aggregated in the data source, no aggregation can be defined for the “slice” that the dimension filter cuts through the values of individual measures. Tableau therefore automatically performs a summation. And because multiple values are defined, the result is the sum of a group of sums.

For example, consider the view shown below, which shows profit by region and state.

![A bar chart that displays profit by state and region.](/tableau/current/en-us/pro/desktop/en-us/Img/hve_calcfilter1.png)

A slicing filter that includes the Q3 and Q4 members of the Quarter dimension is then applied to the data.

![A filter menu for a spreadsheet displaying the options "General," "Condition," "Top," "All," "0," "1," "Qtr 1," "Qtr 2," "Qtr 3," and "Qtr 4."](/tableau/current/en-us/pro/desktop/en-us/Img/hve_calcfilter2.png)

In the resulting view, the profit for Oregon in the West region is 2,567. This number was calculated by summing data values for Qtr3 and Qtr4.

![A bar chart that displays profit by state, with the highest profit in West Oregon.](/tableau/current/en-us/pro/desktop/en-us/Img/hve_calcfilter3.png)

The summation symbol (Σ) you see on the Filters shelf in the view above indicates that this is a slicing filter. If the original aggregation for a field is non-additive (for example, Count Distinct) the values you see after applying a slicing filter may be unexpected.