This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
When I creat a pivot table, with numbers ranging from 0-110 for example, I would like to be able to group those numbers by sets of 5. The problem that comes up is that when I try to sort the slicer or menu it sorts it from smallest to largest like
0-5
10-15
100-105
105-110
15-20
...
Is there any way to actually get it to recognize the numbers contained in the slicer instead of just going off the first numbers? Seems obvious enough that 5-10 is "smaller" but it just doesn't seem to want to sort it that way.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
Excel 2010, PivotTable, Slicer, Sort
With Custom List
http://www.mediafire.com/file/gw61ku4bxcurukb/03_22_11.pdf
http://c3017412.r12.cf0.rackcdn.com/03_22_11.xlsx
If you get *.zip, don't unzip, just rename *.xlsx
Hi,
1.Google Docs; or