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
Bookmarks