COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Active Reports => Topic started by: jerald on 25 Oct 2012 02:00:43 AM

Title: how to display bottom five positive records?
Post by: jerald on 25 Oct 2012 02:00:43 AM
Hi,
     In an active report, I need to display bottom 5 records.  For this I've used bottomCount(Product, 5, volume).  But it's showing only negative values.  But I need bottom five records which is having positive values.  Please help me to proceed!!

with Regards,
Antony Jerald
Title: Re: how to display bottom five positive records?
Post by: MFGF on 12 Nov 2012 06:32:01 AM
Hi,

I think you need to combine this with a filter() function to filter your expression to use Product members only where the volume is positive.

Regards,

MF.