Skip to Content
avatar image
Former Member

Display Last 2 months data in BEX

Hello All,

My requirement is to show Last 2 months of data in a column. For calmonth June 2017, I have to show June 2017 + May 2017 actuals, for May 2017 - May 2017 + April 2017, this keep going for 5 to 6 years period. I don't have any Input variable in my report. Need your suggestions here.

Thanks,

Ashok Kumar

screenshsot.jpg (43.9 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Apr 07, 2017 at 08:41 AM

    Hi,

    Create restricted keyfigures where you restrict each column like you want to, for instance you set 0calmonth as object to restrict

    column 1: a range as restriction: from 0current month to 0current month-1

    column 2: a range as restriction: from 0current month - 1 to 0current month-2

    I was thinking of using only the months and not month/year, but you will have a problem then with January because I presume you will need to count 01.2017 and 12.2016 in one column. If not you can use only Month and put Year above the keyfigrues in the row, so it will do it for all the years.

    Grtz

    Koen

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Koen Hesters, we would not be able to proceed as we have 60 months for now and this keep counting.Thanks for your response. Ashok Kumar