Help with agrr on count cust having more than 1 order on store level

[lmonincx]

I am looking for a way to count per store how many customer did order more than 1 qty

I have the following info

store qty person

abc     1     A

abc     1     A

abc     1     B

abc     1     C

def      1     D

I would like to end up with a  table like

Store     # person

abc          1

Please find attached the qvw, i tried using the aggr but got stuck

Many thanks for the help!

Linda

[anbu1984 · Accepted solution]

count(if(aggr(sum(Qty),Store,person)>1,person))

[lmonincx]

great thanks exactly what i was looking for

[anbu1984]

Pls close the post