I have two fields rank and customer. I would expect my customer to only
appear in the rank that has been assigned to it. However, every customer is
appearing in each rank level. For example Customer A who's rank is Z is
appearing in ranks Z, Y, X and W. What have I done wrong?