I tried to pivot in power query as per fiscal year and fiscal period.
I got the incorrect order for FY and FP as attached.
I also included expected result. I do not mind if the result heading are in month Year or FYFP as long as they are in order for 2 fiscal years.
QFYFPSorting.xlsx (31.6 KB)