Forum Discussion
Help grouping slicer buttons on a pivot table
The request: I have a slicer that reads the cells with values of 0% through 100%. I want to group them in buttons that show 0-9%, 10-19%, ... 90-99% and 100% or something close to that. The de...
For such sample
you may create another PivotTable (in grey) adding only values column (V) to it. Group this PivotTable as desired, add slicer on V and connect slicer additionally to first PivotTable.