Print Page - Chart with Full Year LY and YTD This Year

Title: Chart with Full Year LY and YTD This Year
Post by: bweber on 28 Apr 2012 01:42:04 PM

I want to plot sales data on a chart. I have this year and last year data however when I plot them, it will only show me the last year data up until the current month.

So how can I chart the full year by month of LY values, and then the YTD values?

Thanks,

Brian

Title: Re: Chart with Full Year LY and YTD This Year
Post by: pricter on 28 Apr 2012 02:59:04 PM

Are you using a cube or a relational model?

Title: Re: Chart with Full Year LY and YTD This Year
Post by: bweber on 28 Apr 2012 05:39:44 PM

Relational.

Thanks,

Brian

Title: Re: Chart with Full Year LY and YTD This Year
Post by: pricter on 30 Apr 2012 02:48:31 PM

Create a data item to calculate the month and place it on the x axis
Create a date item to hold the current year sales
for exaple
if (year=currentyear) then (sales) else (0)
Create a date item to hold the py sales

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: bweber on 28 Apr 2012 01:42:04 PM