Add an option in "pivot table" to sort data same as the "original order"
when creating pivot table it will sort data
A-Z, Z-A, or MANUALLY
it will be great if you add another option to allow the sorting the same order as they were. "original order"
Kenneth Barber commented
Workaround: In your source table, add a column with the numbers 1, 2, 3, etc. In your PivotTable, sort your field in ascending order by this new column.
For the record, PivotTables that are based on the Power Pivot Data Model have an additional option to sort by the data source order.