COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Raghuvir on 10 Jan 2014 04:10:26 AM

Title: Last Quarter for Previous Year
Post by: Raghuvir on 10 Jan 2014 04:10:26 AM
Hi All,

I am preparing a report using the GO Sales package and i am trying to achieve last quarter for previous year. i have attached image and written the description of the issue which m facing,in the image itself.

Kindly request you to refer the attached image and help me to find a solution.

thanks in advance!
Title: Re: Last Quarter for Previous Year
Post by: Satheesh on 10 Jan 2014 04:46:03 AM
hi,


use the conditional filter in another list query.
make year = year-1 when Qtr is Q1.




Regards
Sateesh