 | |
| 3 Ways to Display (Multiple Items) in a Pivot Table Filter |
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. 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 Topics:
Post a Comment