Forum Discussion

JMWDBA's avatar
JMWDBA
Icon for Advocate II rankAdvocate II
9 years ago
Solved

Displaying Data in a specific month order

So everything we do in higher education is by academic year, which starts July 1 and ends June 30.  So when I want to display data in a bar graph by the academic year from beginning to end, how would I accomplish this instead of getting alphabetical?

 

I need it displayed in the following order:

 

  • July, August, September, October, November, December, January, February, March, April, May, June

 

With July being the first in the table and June being the last.

Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi JMWDBA

     

    I suggest you to create an additional column in your date table.

    Defining that July is 1, August is 2 an so.

    Then define the sort order by this extra column and hide the extra column.

     

    Please contact me, if you need some help.

     

3 Replies