Unable to get the sort order correct

[sabha]

Hi!
I am having hard time getting the sort order as per financial year.
1. I have drawn the pivot table
2. Grouped all dates to show as months
3. Need to sort the months as per financial year (starting from Apr (2015) to Mar (2016)

Excel by default takes the sort as per calendar year (Jan to Dec). I am attaching the pivot file and appreciate if someone can help me with getting the sort order as per financial year.

Thanks

[romperstomper]

You can manually move Jan - Mar to the end.

[sabha]

You can manually move Jan - Mar to the end.

Thanks for your reply. Jan - Mar dates are already at the end.

[romperstomper]

No, they are at the beginning. You can move them to the end, which is what you asked for.

[stasinek]

Use the grouping by years and months
x.JPG

[sabha]

Use the grouping by years and months
Attachment 453447

Wonderful !
Thank you so much