Sort Input Control - MMM YYYY

[anish_menon]

Hi,

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.

[former_member199945]

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

[anish_menon]

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.

[former_member199945]

Create variable like this -

=FORMATDATE(TODATE([MONTH-YEAR]; "MMM-yyyy");"MMM-yyyy")