I want to sort numbers in ascending sort order, Smallest to Largest. This is not sorting correctly. For example, I right click in a cell in the Totals column of a pivot table and select sort – Smallest to largest. But the total is not sorting in correctly.
What could be the cause?