Chart - sorting by Financial Year

[#1]

Hi,

I have a requirement whereby I need to sort a Line Chart by Months - with the first month being April (April to Mar)

Is there a way I can do this?

Many Thanks

[sujeetsingh]

If it is months then short it like TEXT

[sujeetsingh]

And if you are having a big data then just write up an expression .

[#4]

Could you provide me with an example please?

Will I use the TEXT function in the Expression option in the Sort tab?

Many thanks for your help

[sujeetsingh]

Its ok i am to just exploring......

[#6]

hi,

Type1:use in sort expression

match(Month, 'April','may','jun','jul','Aug','Sep','Oct','Nov','Decr','Jan','Feb','Mar') 

or

Type2:

If

(Num(Month([M Date]))>=4 AND Num(Month([M Date]))<=12,(Num(Month([M Date]))-3),(Num(Month([M Date]))+9)) AS MonthNumber

after using this statement in script

use sort by expression:  = month number.

Hope it will Help

[sujeetsingh]

Brian.

In script editor there is order of month declaration as

SET MonthName=Jan,Feb........

Change it accordingly......as you need

Then sort it accordingly.