Hi there,
I have a pivot table with half a million rows. One of the fields is gross margin which goes from 0% to 100%. I want to insert a slicer on gross margin but instead of showing all the values of GM, I just want to display 3 options in the slicer : 0-25%, 25-50%, >50%. Is that possible without using a macro? Any help is appreciated.

Warm regards,
M