i want to count product which is supplied by only one supplier..
Answer : 3 because break,glass, seat is supplied by only one supplier
how to write expression ? plz
Try in text box
=Count(Aggr(If(Count(DISTINCT supplier) = 1,supplier),product))
is equivalent to
However the list is hardcoded.
Retrieving data ...