Skip to Content
1
Former Member
Jan 06, 2016 at 06:55 AM

Rolling 4 Months Issue

26 Views

Hi All,

I am having issues with creating rolling 4 months in webi report.

Objects i am having YEAR, MONTH NUMBER, SALES AMOUNT

YEAR--> String

MONTH NUMBER-->String

AMOUNT-->Measure

Current Information Looks like

YEAR MONTH NUMBER AMOUNT 2015 04 500 2015 05 150 2015 06 260 2015 07 45 2015 08 85 2015 09 69 2015 10 250 2015 11 320 2015 12 450 2016 01 560 2016 02 410 2016 03 230 2016 04 320 2016 05 150

Need to show Previous 4 Months information, like below.

Year Month Number Amount 2016 01 560 2015 12 450 2015 11 320 2015 10 250

Environment: BI 4.1

Source: BEx