Ordering month in a table according to FY(July to June)

[Matt_Gol]

Hi all,

I have a table that need to show data in each FY, but I stuck with ordering monthes, I know hoe to do it in chartswhen we have tooltips option, but don't know how to do it in tables or matrixes.

Any help would be greatly apprieated.

[Greg_Deckler · Accepted solution]

@Matt_Gol Try creating a sort by column like:

IF(MONTH([Date]) < 7, MONTH([Date]), MONTH([Date]) + 12)

[Matt_Gol]

Thanks @Greg_Deckler for this solution, it works. Much appreciated

[Greg_Deckler]

@Matt_Gol Wow! Unexpected, I did that on my phone! 🙂