This content has been marked as final. Show 6 replies
i want to display count of products which is supplied by only one supplier
load * inline
expression: =Count(Aggr(If(Count( distinct supplier) = 1,supplier),product)) so answer:2 which is correct
now for the same data i am trying to count products which is supplied by multiple supplier
expression: =Count(Aggr(If(Count( distinct supplier) >1,supplier),product)) so answer suppose to be 2 but i am geeting zero
can any help plz.