COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Revelator80 on 16 Aug 2010 05:19:51 AM

Title: Issues pulling back relevant data only
Post by: Revelator80 on 16 Aug 2010 05:19:51 AM
Hi,

I have a top 5 customers report by contract that is filtered on year and category. There are some contracts for which there has been no spend at all this year but that had spend last year and vice versa. When I run the report, all contracts come back regardless of whether there has been spend in the year I selected. I want contracts only to come back where is data for them based on my parameter selections, how can I do this? I would have thought that that would have been the default position but it does no appear so.

Cheers
David