If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Topcount 10 showing less than 10

Started by Lisbeth, 25 Sep 2009 05:06:43 AM

Previous topic - Next topic

Lisbeth

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 ;)

billylodz

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

Lisbeth

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