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.