I am working to make a dashboard in excel. I have one field (let's call is 'Salary1') in my pivot table that contains employee salaries. I would like to create a slicer that will allow me to sort Salary1 in the pivot table. Of course when I create the slicer for Salary1 it gives me every numerical piece of data as a selection option. I can then select an individual number to only view employees who make that salary.
Instead I would like to have the slicer have options that look similar to this with ranges:
<=10000
10001-50000
50001-100000
100001-300000
300001-400000
>=400001
Is this possible to do? Since I am making a dashboard I would like it to be user friendly, but it is not mandatory that a slicer is the tool to do this.
Thanks all!
Bookmarks