cancel
Showing results for 
Search instead for 
Did you mean: 

Rolling 3 Months Sum Key Figure

0 Kudos
120

Hello,

Was wondering the best way to approach the following scenario in bex query designer.

_______01/2009----02/2009--03/2009--04/2009----05/2009

KF 1--


A1
A2

A3

A4
--


A5

KF 2--


B1
B2

B3

B4
--


B5

Explanation of KF 2:

B1 = A1A2A3

B2 = A2A3A4

B3 = A3A4A5

Any help on calculating KF 2 would be great. Thanks.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

Having fiscal period in drill down or drill across and having a keyfigure to populate three months value at single cell is impossible.

You have to data in such a way you requested in dataprovider else you have to go for double structure queries

ie cell editor options in query.

Cell Editor will be the best way for you to implement this. Create two structure in the query one in rows and one in columns.

and you can proceed on restricting each cells with the formulas you need.

Thanks,

Arun