Hi Everyone!
This seems way too simple, and yet I can't find a thread for it.
The source data has people tied to values from 0-100.
I want the slicer's values to sort in decile bands (0-9, 10-19, 20-29, etc...) without having to add an extra column to the source data.
For example I want to be able to click on a "0-9" button in the slicer, and see a list of people with a 0, 1, 2, 3, 4, 5, 6, 7, 8, or 9 next to their name - not a "0-9".
I feel like this should be so easy with a VBA code, but I can't find a thread with this specific question.
Thanks in advance!
This seems way too simple, and yet I can't find a thread for it.
The source data has people tied to values from 0-100.
I want the slicer's values to sort in decile bands (0-9, 10-19, 20-29, etc...) without having to add an extra column to the source data.
For example I want to be able to click on a "0-9" button in the slicer, and see a list of people with a 0, 1, 2, 3, 4, 5, 6, 7, 8, or 9 next to their name - not a "0-9".
I feel like this should be so easy with a VBA code, but I can't find a thread with this specific question.
Thanks in advance!