Print Page - how to display bottom five positive records?

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.

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