If you create a calculated item in the pivot table, you'll see each
customer for each rank level. Could that be the problem?

wrote:
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?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html