Forum Discussion
Solved
Slicer duplicates
Created slicer from pivot table and "Assigned" appears twice although it's only reflected once in the drop down list. How do i remove the duplicate? Thanks
It's possible the second entry for "Assigned" is not the same as the first entry. There could be a leading or trailing space in the cell. I recommend checking the source data for the pivot table to make sure the data is clean then refresh the pivot and the slicer will fall in line.
It's possible the second entry for "Assigned" is not the same as the first entry. There could be a leading or trailing space in the cell. I recommend checking the source data for the pivot table to make sure the data is clean then refresh the pivot and the slicer will fall in line.