Skip to Content
avatar image
Former Member

Sorting Month Year in Webi Chart 4.1

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Apr 20, 2017 at 10:09 AM

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

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 20, 2017 at 01:05 PM

    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

    Add comment
    10|10000 characters needed characters exceeded