Hi Everyone,
In my ODS I have monthly energy usage by customer. In my query I have to show rolling twelve month energy usage.
How do I create the CKF?
I think a normal Sum of months from Jan to Dec is not right. I have to consider the present month and calculate for the past 11 months including this month. How do I go about this.
You are your views. Your help will be greatly appreciated.
Thanks
Kumar.