Print Page - Show only where distinct count = 1

Title: Show only where distinct count = 1
Post by: RGascoigne on 23 Aug 2017 02:30:25 AM

Hi,

I'm trying to show where a location has only a single item. I have a list showing distinct count of items by location, however I only want to see when the distinct count is 1.

Any ideas?

Rob

Title: Re: Show only where distinct count = 1
Post by: hespora on 23 Aug 2017 02:37:55 AM

filter on the count and set filter to *after* auto aggregation.

possibly might not work; if so, then create a query reference instead.

Title: Re: Show only where distinct count = 1
Post by: RGascoigne on 23 Aug 2017 02:49:30 AM

filter on the count and set filter to *after* auto aggregation worked fine.

Thanks for your help :)

Title: Re: Show only where distinct count = 1
Post by: hespora on 23 Aug 2017 06:20:53 AM

sure thing; glad I could help.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: RGascoigne on 23 Aug 2017 02:30:25 AM