Last 12 months rolling sort on fiscal chart

[sifatnabil]

Hi all,

I have a bar chart with Dimensions:

FiscalMonth (e.g. Apr, May, Jun, Jul, etc)

FiscalYear (e.g. 2013/2014, 2014/2015, etc)

On expression I have sum(Revenue)

Right now the dimension axis sort goes like this:

Apr, May, Jun, Jul...Mar

How can I sort the dimension axis such that it always shows the last 12 months with the current month as the last value? i.e. for this month, it would be

May, Jun, Jul, Aug, Sep, Oct, Nov, Dec, Jan, Feb, Mar, Apr

Next month, it would be

Jun, Jul, Aug, Sep, Oct, Nov, Dec, Jan, Feb, Mar, Apr, May

[sunny_talwar]

I guess try using a sort expression with just DateField

[sunny_talwar]

or may be MonthStart(DateField)

[swuehl · Accepted solution]

Try

=Max(YourDateField)

as sort by expression with a ascending sort order to show the current month as last value.