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

how to display bottom five positive records?

Started by jerald, 25 Oct 2012 02:00:43 AM

Previous topic - Next topic

jerald

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

MFGF

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.
Meep!