Pivot data appearing wrong.

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?

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

[email protected] 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