---
schema_version: "1"
id: 27a2f0cbcb3bebba39844a8d58a1aa7972791b6ee08b7ab630ebd56ba1291f16
title: Create Slicing Filters
collection: tableau
version: next
locale: en-gb
portal_url: https://docs.salesforce.com/tableau/next/en-gb/pro/desktop/filtering_calculation.md
canonical_url: https://help.tableau.com/v0.0/pro/desktop/en-gb/filtering_calculation.htm
source_site: help.tableau.com
content_type: documentation
content_hash: 0850ff6b9347cc5c644b410dca4425412bc073c0f2146b01fa671ea615d935aa
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/next/en-gb/pro/desktop/en-gb/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/next/en-gb/pro/desktop/en-gb/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/next/en-gb/pro/desktop/en-gb/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/next/en-gb/pro/desktop/en-gb/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.