Pivot table list values not in sequence

Brass Contributor

Why my pivot table listing sequence is not in series as the original data . Attached is my sample workbook for reference .

2 Replies

@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.

Screenshot 2021-03-04 at 05.45.40.png

Thank you the problem is solved now.