this is a slicer but it's not filtering a pivot table so how does this work first turn your data into a table with contrl t and click okay select a cell in your table table design Check Total row insert slicer select the elements to filter by okay move the slicer to the top and the slicer filters the table
Comments