Integrate count in set analysis

[#1]

I THINK I would like to use a count() expression within a setanalysis of another count as I am trying to accomplisch the following:

I would like to count the amount of companies that have done over 3 productregistrations. My datastructure is setup that every piece of volume has a separate id (productregistration.id).

Therefore if i would like to count the amount of pieces a company has done, i do:

=Count(

{<

RevenueDateMONTH={$(vGlobalMonthSelect)},RevenueDateYEAR={$(vGlobalYearSelect)}

>}Productregistration.Id)

But now i would like to count the amount of companies that have more than 3 productregistrations; and I wanted to approach it something like this:

= COUNT( {<

Count(

{<

RevenueDateMONTH={$(vGlobalMonthSelect)},RevenueDateYEAR={$(vGlobalYearSelect)}

>}Productregistration.Id) ={'>3'}

>} Account.id)

What is the proper way of setting this up?

[teempi]

Hi rtummers,

Try something like this:

= COUNT( {< Account.id={"=Count( {< RevenueDateMONTH={$(vGlobalMonthSelect)},RevenueDateYEAR={$(vGlobalYearSelect)} >}Productregistration.Id) >= 3"} >} Account.id)

-Teemu