Skip to Content
avatar image
Former Member

12 months rolling in webi

Hi,

I am new to the webi. I wanted to create a report from BEx query.  But I am consfused how to filter for 12 months rolling i.e. from current month - 3 to current month + 9.

Appreciated 😊

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Nov 02, 2015 at 07:30 AM

    Hi Hikoe,

    In BEx query you can achieve this using a filter on calmonth.

    Use the standard calmonth variable 0Cmonth and use offset of -3 and +9 to achieve this.

    0Cmonth is the standard sap BEx variable for current month.

    Hope this helps.

    Regards,

    Amit

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      yes. Thanks for your info. Since the requirment is to create the formula, I have to proceed the complicated one. Anyway, appreciated your point of guideline 😀

      thanks

      Hikoe