Hi
I have a slicer connected to a pivot table which has alpha numeric values sorted in the following manner:
0 to 3
10 to 12
13 to 15
16 to 17
4 to 6
7 to 9
All Ages
Obviously, the above is out of order, however, it is sorted correctly in the underlying data and in the pivot table as well. So is there a way to correctly sort it in the slicer?
I only see slicer sorting options for ascending and descending.
Paul
Bookmarks