Print Page - Count within expression set

Title: Count within expression set
Post by: Azzoz06 on 20 Sep 2011 10:15:06 AM

Hello all,

In an Active Report using a Cube I'm trying to build a report which counts members of a level taking into account the parent level selection.
I don't think Active Report brings any difficulties cause I can't get my results properly in a "normal" report.

Product Line #of Product Lines
Golf Equipment 4
Camping Equipment 9
....

The expression I build just counts the number of distinct Product Lines (overall) not considering the breakdown on Product Line using something like count(1 within set .....)

Thanks for your help

Title: Re: Count within expression set
Post by: MFGF on 20 Sep 2011 11:13:59 AM

Hi,

I'm not quite sure I follow what you're trying to do. Are you counting the products within each product line? Or do you just want the overall count of product lines? Or something else?

MF.

Title: Re: Count within expression set
Post by: Azzoz06 on 20 Sep 2011 11:29:44 AM

Hi,

Yes right trying to count the Products within each Product Line.

Sorry for not being clear.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Azzoz06 on 20 Sep 2011 10:15:06 AM