Custom Data Displayed in Columns

[Nickbruno]

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.