Sign up for our Excel webinar, times added weekly: [ Ссылка ]
In this video we look at 3 ways to list or display the (Multiple Items) that are selected in the Filters area of a pivot table.
Download the file to follow along: [ Ссылка ]
When we filter for more than one item, the cell that contains the filter drop-down menu displays the phrase (Multiple Items). There is no built-in way to see what items the pivot table is being filtered for unless we open the filter drop-down menu and scroll through the list.
However, there are a few simple ways to display this list on the worksheet. We can use a slicer, connected pivot table, or simple formula using TEXTJOIN or CONCATENATE to display the filter list. Each solution is pretty easy to implement.
Related videos:
Slicer and Pivot Table Relationships Explained: [ Ссылка ]
How to use Slicers - Beginners Guide: [ Ссылка ]
3-Part Video Series on Excel Filters: [ Ссылка ]
3-Part Video Series on Pivot Table & Dashboards: [ Ссылка ]
00:00 Introduction
01:27 Add a Slicer
02:34 Connected Pivot Table
06:08 Text Join
3 Ways To Display Multiple Items In A Pivot Table Filter
Теги
excelpivot tablesslicersformulasfunctionsTEXTJOINexcel campuspivot tablepivot table in excelexcel pivot tableshow to use pivot tablepivot table tutorialcreate a pivot tableexcel tutorialexcel pivot table tutorialpivot table excelexcel pivot tablehow to use pivot tablescreate pivot tablemicrosoft excel (software)how to make a pivot tablems excel - pivot table super trickpivot table super trick in ms excelpivot table excel advanced
