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)
I have problem with ascending sorting of numbers in a PivotTable in Office 2010.
In my source the numbers are in a correct order, but in the PivotTable my numbers are not in a correct order.
Source:
PivotTable:
I want to sort the Nr. column in the PivotTable in ascending way: 2, 4, 6, 8, 10, 12, 14, 16, 18, 20.
I tried to sort it, but the result is not what I want.
Can anyone help me, please.
With so thanks,
Dio
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
If you click the filter shown next to Nr, you will be presented with More Sort Options where you can select sorting order for Nr.