Skip to Content
0

Display Last 2 months data in BEX

Apr 07, 2017 at 01:07 AM

76

avatar image
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

screenshsot.jpg (43.9 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Koen Hesters Apr 07, 2017 at 08:41 AM
0

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

Show 1 Share
10 |10000 characters needed characters left 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

0