Pivot data appearing wrong.

B

brandysommerfel

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?
 
D

Debra Dalgleish

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