Skip to Content

Sort Input Control - MMM YYYY

Mar 05 at 12:18 PM


avatar image


Need help in sorting Month Year Value in an input control in a webi report.

I have seen posts where we are sorting a table/chart by adding Year into it.

But here I am using the Month Year value in an input control and it needs to be in a sorted format.

For example:

APR 2016

MAY 2016

JUN 2016

and so on..

As of now its sorting alphabetically and showing as below:

APR 2016

AUG 2016

DEC 2016

Also the Key/Text values for the Month dimension are same.

Using SAP BO 4.1 SP7. Webi Report based out BEx Query.

10 |10000 characters needed characters left characters exceeded

create variable on top of existing object which was used as input control and apply custom sorting to this object.


Thanks for the reply..

I know but Custom Sorting won't help when you have new values coming in on a monthly basis. We will need to keep adding them on a monthly basis.


Create variable like this -


* Please Login or Register to Answer, Follow or Comment.

0 Answers