Arrange the Fiscal period month wise in webi report

[former_member530232]

Hi All,

Need one help. I have a below KPI which is populating through a Bex query.

Now if you see the Fiscal Period is not in order.Can anyone suggest me how to arrange the Month Year in Jan -->Feb--> and so on.

Thanks in advance.

Regards

Faizan

[Former Member · Accepted solution]

Create a dimension to extract month Number

[SortOrder]=MonthNumberOfYear(ToDate([FiscalPeriod];"MMM yyyy"))

Then right click on graph select Sort the Block based on this [SortOrder]

Here FiscalPeriod is the dimension that displays FEB 2016 in your graph

Regards

Niraj

[former_member530232 · Accepted solution]

Thanks Niraj for your help. It worked!!

[vijaymuniraj]

Hi Faizan Arefin

Close the thread.

[former_member530232]

Vijai...can you please guide me how to close the thread?

[vijaymuniraj]

Hi,

When you mark someone's comment/reply as Correct Answer(which you got solution to your issue), that is considered as closed.  You have done it now!

[former_member198519]

Here is a blog which show what need to be done for sorting the months in a webi chart. Have a look:

[former_member530232]

Thanks Kuldeep. Yes it worked!!

[former_member198519]

Glad it worked