CODEWITHSUNDEEP
excelsortingdatepivot-table
UserX
UserX

Reputation: 159

Pivot table Sort month for different years

Hi I am pivoting data grouped by months. The months are spanned across 2 years with the start date being in july 2018 going back to august 2017. However when i try to sort the data, it always start with Jan 2018 first and goes alphabetically. How can i make it do chronologically. Also is there a way to change the date to say m/yy? I keepy trying field settings then number format and its not working

Date
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
<8/1/2017

Upvotes: 0

Views: 2705

Answers (1)

Marco Vos
Marco Vos

Reputation: 2968

An option could be to group years as well. Right-click a cell with one of the months > group > select Years and months. This will put the months in chronological order.

Upvotes: 3

Related Questions