Fiscal month sort order

[#1]

Hello

I have a bar graph with a cyclic group to toggle between calendar months and fiscal months.

My code for the fiscal month is :

,MonthName(AddMonths($(vDateField), -3)) as FISCAL_MONTH_YEAR

In order to distinguish this as fiscal I wanted to add the 'FY' suffix as such:

,MonthName(AddMonths($(vDateField), -3)) & 'FY' as FISCAL_MONTH_YEAR

but when I do so it then totally messes up the sort order. Months are all over the place ie. The current sort order for the cyclic group is

set to numeric - ascending for both calendar and fiscal.

Any help /ideas much appreciated.

Thanks

[MarcoWedel · Accepted solution]

Dual(MonthName(AddMonths($(vDateField), -3)) & 'FY',MonthName(AddMonths($(vDateField), -3))) as FISCAL_MONTH_YEAR

[#3]

Ah still no joy Im afraid ....

[sunny_talwar]

Will you be able to share a sample data or sample qvw file for us to see what is not working?

Best,

S

[#5]

Marco - thanks this worked perfectly and in line with what Colin mentioned previously.

Thanks all