Sort Order

[kevbrown]

I have a chart and a graph that run off the same data.  I need to sort both by a column called "CL_Q". This column shows the following values -

Qtr1, Qtr2, Qtr3, Qtr4, Nov-2013, Dec-2013, Jan-2014,Feb-2014, Mar-2014, Apr-2014, May-2014, Jun-2014,Jul-2014, Aug-2014, Sep-2014, Oct-2014.

Depending on the year I select my chart and graph will show either the quarters or the months, which works fine, however the sort order of the months is by name not date, so Apr-2014, Aug-2014 etc.  How can i get it in the correct order in the chart properties and not in the script?

Thanks

Kev

[anbu1984 · Accepted solution]

Use expr Date#(CL_Q,'MMM-YYYY') on Sort tab

[kevbrown]

Superb, thank you.

[MK_QSL]

Define your Month-Year Field in sort expression

Go to Sort Tab

Write Below in Your Sort Expression

Date#(CL_Q,'MMM-YYYY')

This will consider your Month-Year Field as Numeric

Now you can sort by Ascending or Descending Order...