Mar 03 2021 08:27 PM
Why my pivot table listing sequence is not in series as the original data . Attached is my sample workbook for reference .
Mar 03 2021 08:48 PM
@Liphor Several cells that contain the year have an apostrophe in the beginning. This messes up the sorting. Remove these and resort. Then it will work as expected.
Mar 03 2021 11:32 PM