Count within expression set

[Azzoz06]

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

[MFGF]

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.

[Azzoz06]

Hi,

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

Sorry for not being clear.