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. The summation symbol (Σ) you see on the Filters shelf in the view above indicates that this is a slicing filter. This number was calculated by summing data values for Qtr3 and Qtr4.
![excel how to add slicer to filter by time excel how to add slicer to filter by time](https://img.chandoo.org/pivot/slicers/interactive-chart-with-slicers.gif)
In the resulting view, the profit for Oregon in the West region is 2,567. And because multiple values are defined, the result is the sum of a group of sums.įor example, consider the view shown below, which shows profit by region and state.Ī slicing filter that includes the Q3 and Q4 members of the Quarter dimension is then applied to the data. Tableau therefore automatically performs a summation. Tableau recalculates values for each measure in the view using the configured aggregations.īut 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. For example:įor relational data sources, there is nothing remarkable about a slicing filter. Now we just add a slicer to the pivot table for this new field (1st Initial). Add a Slicer for the Parent Level Group Field.
![excel how to add slicer to filter by time excel how to add slicer to filter by time](https://extendingdynamicsax.files.wordpress.com/2013/10/103113_1410_addingtimel1.png)
The filter is defined to include multiple values. You can filter the 1st Initial column in your source data for C to see a list of all the data for all the reps that have a name starting with C. The dimension that you place on the Filters shelf is not also on any other shelf in the view. In Tableau, multidimensional data sources are supported only in Windows. 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.