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.
1 Reply
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.