Display Last 2 months data in BEX

[Former Member]

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

[kohesco]

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

[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