8 Replies Latest reply: May 15, 2016 7:54 PM by Franc Max RSS

    Month sort order on chart with input date range

      I have a bar chart with month on x axis and Sum(sales) on y axis.I can sort the chart by fiscal month order or calendar month order.However, when I select the date range from say nov-2011 to jul-2012,my chart does not show Nov through Jul .It either shows Apr -May-Jun-Jul-Nov-Dec-Jan-Feb-Mar(Fiscal sort order) or jan-Feb-Mar-Apr-May-Jun-Jul-Nov-Dec(Caledar month sort order).I want it to show Nov-Dec-Jan-Feb-Mar-Apr-May-Jun-Jul. I have tried load order etc with no luck.Help please.