Skip to Content
0

Sorting Month Year in Webi Chart 4.1

Apr 20, 2017 at 09:40 AM

85

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Kuldeep Ghosh Apr 20, 2017 at 10:09 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Mahboob Mohammed Apr 20, 2017 at 01:05 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded