Time-bound measure to replicate an Excel graph

[cognox]

I have an Excel chart where the data (coming from Cognos reports) is manually entered and I'm trying to recreate the report in Cognos Analytics R12 - please see attachment. I've tried both Dashboard and standard report, but I haven't found a way to create the same report.

The measure I am using is profit and the table is showing the current and prior rolling 12 values. But in Cognos there is no time-bound measure. It cannot be used in two separate rows of a table (comments/corrections?). As for the target, I've created a calculated field.

I appreciate comments on how (if at all) I can recreate the graph in Cognos.

[cognostechie]

Rolling 12 months is a very common thing in cognos. It's called 'relative time category'. It all depends on how you define it. What is the time period of 'Current R 12'? Does it mean 12 months going backwards starting from today? What is Prior 12?

These time buckets are usually created in the package which you are using to create the report. Once that is done then you can simply drag and drop it in the chart.

Which tool is being used to create the package?

[cognostechie]

It can also be done in the report but best if done in the package.