Skip to Content
0

Sort Input Control - MMM YYYY

Mar 05 at 12:18 PM

35

avatar image
Former Member

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.

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.

0
Former Member
seshu P

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.

0

Create variable like this -

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

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

0 Answers