COGNOiSe.com - The IBM Cognos Community

Hi, :) :)
I have a Relational Implementation,

I have the following situation in our database table.
CAR ID          DATE SOLD            STATUS
BMW-1010     01/02/2015            IN GARAGE
BMW-1010     01/03/2015            NEW
BMW-1010     01/04/2015            IN GARAGE
BMW-1010     01/05/2015            NEW
BMW-1010     01/06/2015            IN GARAGE
BMW-1010     01/06/2015            NEW

So, the above should show me a count of 3 based on IN GARAGE and NEW for the SAME CAR ID.
Is there a way to handle this within the Report Studio or Framework Manager?

Thanks for your time.

Try this.
Count([DATE SOLD] for [STATUS])

almost, I'd say

count([date sold] for [Car ID],[Status])


If you just count for status, that fails as soon as multiple cars are in the report.

Thanks so much! I'll try that..  :) :)

Quote from: hespora on 06 Jun 2017 11:02:44 AM
almost, I'd say

Code Select Expand


count([date sold] for [Car ID],[Status])


If you just count for status, that fails as soon as multiple cars are in the report.

You are right. Of course, it depends on the underlying dataset.

Yes, that worked. Thanks a lot