Skip to Content
0
Former Member
Mar 23, 2009 at 06:21 PM

Sum of Rolling twelve months

74 Views

Hi Everyone,

I have a requirement to add a key figure which displays the "Sum of Rolling twelve months" of KF "Energy Usage."

I have Monthly Usage KF in my ODS (like Jan usage, Feb usage .. thru .. Dec usage).

In the query I not sure how to create the Calculated KF and Restricted KF.

The User will enter a Date and the query has to calculate Sum of Rolling twelve months including this month.

Can you please give me the steps of what CKF's I have to create and how to sum up the last twelve months.

Your help will be greatly appreciated.

Thanks

Kumar.