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.
Go to Solution.
@Matt_Gol Try creating a sort by column like:
IF(MONTH([Date]) < 7, MONTH([Date]), MONTH([Date]) + 12)
View solution in original post
Thanks @Greg_Deckler for this solution, it works. Much appreciated
@Matt_Gol Wow! Unexpected, I did that on my phone! 🙂
Vote for your favorite t-shirt design now through March 28.
Find out more about the March 2023 update.
Find out more about the online and in person events happening in March!