• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Create a slicer that covers multiple columns in a table

deabottamus89

New Member
Hi everyone,

I've created a table that columns for Product, Strategy and Staff Member 1, Staff Member 2....Staff Member 5. Various staff members can be assigned to the same Product or the same staff member e.g. Collins may be assigned to multiple products but the staff member may not always be in column for Staff Member 1 or Staff Member 2 etc which makes filtering for Collins difficult. Is there a way to create a slicer that covers multiple columns? Such that you filter for "Collins" (to use an example) in the slicer. Thanks in advance. Dbot
 
Create a slicer to filter data
  1. Click anywhere in the table or PivotTable.
  2. On the Home tab, go to Insert > Slicer.
  3. In the Insert Slicers dialog box, select the checkboxes for the fields you want to display, then select OK.
  4. A slicer will be created for every field that you selected. Clicking any of the slicer buttons will automatically apply that filter to the linked table or PivotTable.
  5. You can adjust your slicer preferences in the Slicer tab (in newer versions of Excel), or the Design tab (Excel 2016 and older versions) on the ribbon.
  6. If you want to connect a slicer to more than one PivotTable, go to Slicer > Report Connections > check the PivotTables to include, then select OK.
Hope this is helpful. You can get more details on Apps4Rent.

Regards,
Jerry M
 
Hmm, a bit of wizardry is required, but it ain't that difficult.
For sure an even better solution is possible using VBA, but this is a set-up without needing to program.

72691
 

Attachments

  • Chandoo45314_create-a-slicer-that-covers-multiple-columns-in-a-table.xlsx
    19 KB · Views: 170
Back
Top