Great question today that I picked up in my Learn Excel from MrExcel Podcast, Episode Only 2 or 3 cell styles are useful, in my opinion. This is found in the Cell Styles gallery. In the figure above, I applied the Title style to cell A1. Use TEXTJOIN to concatenate all of the row field items from the second pivot table. Putting True there will prevent a bunch of extra commas appearing at the end of your list. The second argument is called Ignore Empty. This new function was introduced in February 2017 for Office 365. Use the formula =TEXTJOIN(", ",True,Z4:Z20). ![]() Right-click the Grand Total and Remove Grand Total. Your pivot table will consist of a heading, a list of the selected Sectors, and a cell that says Grand Total. Take whatever is in your slicer and move that field to the Rows area. Remove all fields from the new pivot table. You want this pivot table to be outside of the print area and outside of one screen of data. Move far to the right and paste a copy of your pivot table. So - here is the solution that I offered to Joy in Houston. ![]() Report filter works as a title with only one item selected.īut as soon as you select 2 or more items from the slicer, then the title becomes (Multiple Items). If you put the Sector field in the Report Filter, you have a great title in B1 showing what is selected. Say that you only select one item from the slicer or Report Filter. I love slicers, because they can show you all of the items selected. Joy attended my Houston Power Excel seminar and asked if there was a way to show the items selected in a slicer in a cell above the pivot table.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |