Pivot table sorting

[thebraketester]

Afternoon all..

Is it possible to change the sort of dates in PT so it sorts from lets say July-June, rather from Jan-December?

Thanks
TBT

[mmm-five]

Are you saying you want to see January 2023 AFTER July 2023?

Or do you want the filter (not the sort) to only start at July 2023 and up to June 2024?

[paulrockliffe]

Right click on it and there is a custom sort option I think.

You can also do this using Power Pivot by adding a custom column that is 1 for July, 2 for August etc, then you can set that new column as the sort column for the month column.

[Murph7355]

Do you mean sorting the months in reverse chronological?

If so, yes.

If you've entered the data correctly, you should see a drop down icon next to the column name. Click it and change the sort order

[thebraketester]

Sorry. Just to clarify. This in numbers too, so it might be a limit of the program.

Instead of

Jan
Feb
Mar
....

It would be nice to sort

July
August
Sep

Thanks

[Ultuous]

I'm going to hazard a guess that the op wants to sort the data across a tax year or similar - if that's the case, just include the calendar year alongside the month in the source data and the world will be a better place!

[Murph7355]

thebraketester said:

Sorry. Just to clarify. This in numbers too, so it might be a limit of the program.

Instead of

Jan
Feb
Mar
....

It would be nice to sort

July
August
Sep

Thanks

You're not helping! What do you mean?

Show the whole dataset you are trying to sort.

[thebraketester]

Ultuous said:

I'm going to hazard a guess that the op wants to sort the data across a tax year or similar - if that's the case, just include the calendar year alongside the month in the source data and the world will be a better place!

Ahh haaaa.... sorted *pun intended

Source data has full date so if I select sorting by Y/M instead of just M, that does what I want.... Thank you.

TBT