Hi,
I'm trying to build a budget vs actual report in cognos report studio.
I have my cost centers running down the right & corresponding GL accounts on the page explorer (what user sees)
In the query explorer I am totaling 2016 activity the to get a monthly budget amount dividing it by business days in the year & multiplying that run rate by the number of business days in that month in 2017 with in the data item expression box. I am doing this for each month.
I need to display columns on the report that prints out as such 2017 Month Actual, 2016 Month Actual, 2017 Budget, & then the same three for CYTD data.
I'm not sure how to calc the CYTD & make it dynamic & wondering if displaying all this different types of data is possible in a cross tab or if I should use another format...or if its just not possible.
Needless to say I don't have a lot of cognos experience.
Thanks for any help you can provide.