Skip to Content

Rolling Period COPA Report

Jul 11, 2017 at 09:00 PM


avatar image

Hello, I am trying to create a KE31 COPA drilldown report using 12 rolling periods. I am using a one axis with key figures form in this regard. I have created formula variables from t code GS12 with table GLT1, field RPMAX, that use an evaluation period and year to calculate the previous period, i.e.

IF 'ZRRP00' > 1 THEN 'ZRRP00' - 1

Else 12

I created 12 month and 12 year variables with similar logic, but as stated didn't use KE3E. These variables are requiring individual entry on the selection screen instead of deriving the previous period from the eval period.

Is there a way to create rolling formula variables using KE3E for auto derivation of the previous period and associated prev year if the previous period is 12?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers