💻 Software
How to preserve sort order in Excel Pivot-table?
Fresh5 days ago
Mar 15, 202641178 viewsConfidence Score0%
0%
Problem
I have a worksheet with data that is sorted in certain order (data is coming from external source, so there are four "ORDER BY" columns that create the desired sort order but are hidden on worksheet). However when pivot-table is created, it changes the sort order by sorting on each column selected …
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: How to preserve sort order in Excel Pivot-table?
Low Risk
Assign serial numbers to the data in another hidden column and use that to sort the pivot table data. If needed the serial numbers can be included in the pivot table and then hidden. Serial numbers can be inserted either using a formula that adds on…
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix