I need your help. I have YTD data. I want to create MTD from YTD. Can I do that?
I want the data processed in script, not in expression. After this finished, expressions are much easier. And I'm stuck hehehe...
I attached the qvw in here.
Please kindly your help.
Note: the "Date" column is in month data. 1/1/2012 means jan 1, 2012. 2/1/2012 means feb 1, 2012. This BI is for our group, that's why we have more than 1 company in this sample.
Thanks & Regards,