Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to Display previous 12 months data in month wise (i.e Dec-2014-Jan-2015-Feb-2015)like that

How to Display previous 12 months data in month wise (i.e Dec-2014-Jan-2015-Feb-2015)like that

Please refer above

replied

Hi,

For sorting by month and year follow below steps.

Create variable Month=FormatDate([Period date];"Mmm")

Year=FormatDate([Period date];"yyyy")

Place these two variables above the Month-Year variable.

Right click on the Month->Sort->Advance->Custom Order->Values and select the Months order.

After this apply the Ascending order on the Year variable.

Check format is coming correct or not.

Right click on the Month variable and Hide it.Same for year Hide it.

Regards,

Amit

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question