Skip to Content

Rolling Period COPA Report

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers