Learn Excel - Slicer Selections in Title - Podcast 2202

Joy in Houston asks: Can I show the information selected in the slicer as a title above the pivot table? Historically, going back to Excel 2007, the Report Filter would say (Multiple Items) when you selected multiple items. What are the multiple items? Slicers are an improvement because you can see the items. But what if we want to get the Slicer values back above the pivot table, better than (Multiple Items) Build a pivot table and add a slicer. Copy the pivot table and paste it to the right. This makes the pivot table automatically connected to the slicer. Put only the slicer field in Rows. Delete the Grand Total row Use TEXTJOIN to put the slicer in a cell To download this workbook: https://www.mrexcel.com/download-center/2018/05/slicer-selections-in-title.xlsx List of upcoming seminars: https://www.mrexcel.com/press-appearances/