Print Page - Topcount 10 showing less than 10

Title: Topcount 10 showing less than 10
Post by: Lisbeth on 25 Sep 2009 05:06:43 AM

Hi!
I have a cross tab showing eg revenue and order amount.
I have made a topcount (chains);10;tuple(revenue;current month). However, on some of my markets there's only 6 chains with revenue this month - and then I only want to show these 6 chains. But, I get the 6 chains plus 4 "extras" with no revenue on (they have an order amount, and therefore they do not get zero suppressed).
Can I set a property or something else on my topcount to solve this problem?
Thanx in advance ;)

Title: Re: Topcount 10 showing less than 10
Post by: billylodz on 25 Sep 2009 09:47:53 AM

filter(topcount (chains);10;tuple(revenue;current month),tuple(revenue;current month)<>0)

Title: (Solved) Topcount 10 showing less than 10
Post by: Lisbeth on 28 Sep 2009 03:07:26 AM

Thanks a lot - will begin using the filter function a lot!

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Lisbeth on 25 Sep 2009 05:06:43 AM