Sorting Month Year in Webi Chart 4.1

[former_member206223]

Hi,

I am using SAP BO 4.1 with relational universe on SQL Server.

How can i sort Month Year in in chart x axis, i have an object which has Mon YYYY like Apr 2016, Jan 2016.

Is there any way i can get the months sorted as Jan 2016,Feb 2016,Mar 2016,Apr 2016 etc by using variables in Webi.

Thanks,

Harsha

[mhmohammed]

Hi Harsha,

Check out this blog, you can use a similar logic, by creating a variable by concatenating Year and Month number, by creating a variable as below which would return (201701, 201702, 201703... for Jan, Feb, Mar of 2017), use that in the chart, sort on it and hide it, as shown in the image.

v_YearMonth =FormatNumber(Year([Date]);"0000")+FormatNumber(MonthNumberOfYear([Date]);"00")

Thanks,
Mahboob Mohammed

[former_member198519]

Did you tried doing a Custom sort on Month-year object?