Customers who do not buy enough

[Anonymous]

Hi ,

i would like a pivot table with customers that have buy only less of  5 items

my dimension is

=AGGR (( count(distinct items), customers) < 5  ,customers)

but not kork....

any help?

Thank

[Anonymous]

hi ,

i have solved like this :

=aggr(if( count( distinct (items)) < 5, customer),customer)

[SunilChauhan]

i belivee aggr is not require here

take

variable

v1=count( distinct (items))

and if($(V1)<5,customers)

i thing it will better because sometime aggr srinks the data.

[#4]

Seem to me as  the aggr is reduandent. Something like this would do the trick:

Dimension:

customer

Expression:

If(count(distinct items)>4,1) , hidden, suppress missing/zero values