How to get previous month's values for current month

[Former Member]

Hi..

I have a requirement on a report, where for a particular month, the key figure value should be from the previous month.

Eg: KF1 value for Sept 2007 should come from Aug 2007, KF value for Dec 2007 should be the value of Nov 2007, etc.

There are other key figures on the report which do not need this logic. It is only for one key figure.

Should we do this on the backend or front-end, and how? Any tips will be appreciated.

Thanks

R.

[Former Member]

Hi

That won't work for us because if I say current month - 1, even for Dec 2007, it will give me the key figure value for Aug 07 (since current is sept).

What i need is , for every month, it should pick up the value from the preceding month.

[Former Member]

Hello Riya

Use a customer exit variable to get previous month and then restrict the KF with this variable

Thanks

TRipple k

[Former Member]

hi,

Use a Restricted Keyfigure.

Drag your KF1 and Drag Calandar Month with a Variable Current Cal Month with variable Offset to -1.

KEERTTHi