Hello

Can someone suggest how I can overcome this problem.

I have a pivot table calling data from a SQL view, however the data has duplicates on a UserID field - this is necessary as sometimes the user will wish to see the number of orders, but this doesnt help when wishing to view the unique UserIDs.
Is there a way to overcome this, either by VBA or a function ?!

Thanks for any help
Amy x