Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Use expr Date#(CL_Q,'MMM-YYYY') on Sort tab
Use expr Date#(CL_Q,'MMM-YYYY') on Sort tab
Superb, thank you.
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...