Sorting by Fiscal Year

[darrellbutler]

Hi folks,

I have a data set that includes month i.e 01 = Jan, 02 = Feb 12 = Dec. Together with a Year_Month in the format 201004 = Apr 2010, 201005 = May 2010 etc.

I have a line chart and I'm trying to show sales volumes over 3 years. I want to sort my x axes starting from April going through to March but at the moment I'm dtruggling to do this.

I've added two Dimensions Month & Year_Month, Month does not have any sort order, Year_Month has a descending order based on a numeric value.

Any help would be greatly appreciated

[john_duffy]

Hello.

I have attached a sample application which creates a resident table to determine the monthly sort order. The line chart then uses the sorting field in the Sort by Expression to have the x axis go from April to March.

Let me know if this helps.

John.

[darrellbutler]

John,

Sorry for the late response - I was demoing my first app so things were hectic !

This helped greatly - thank you very much indeed.

Kind regards

Darrell