Good morning

I remember your original question - trying to figure out what you were counting -

The answer to this question lies in the data - see the example below - this totals 2 seasons but one participant -

but it I add address there are 2 separate records - look at the address - they are not the same - probably a data entry error -

there are others also

Jim

If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

Before yo clean it by hand try Tableau Prep (you can access a free trial at Tableau Prep

it is a new Tableau product developed to clean, join and restructure data

see the link below -   https://onlinehelp.tableau.com/current/prep/en-us/help.html#prep_clean.html%3FTocPath%3D_____5

I was on the Beta and it does a really nice job for data like yours

Jim

I hear you -

good luck

Glad to help out

Jim

Hi Jessica, If you have Tableau Desktop License you also have the Tableau Prep License. Check the Tableau customer portal in the My Keys area:

https://customer-portal.tableau.com/s/my-keys

Oh, right... Sorry

Good luck. Hope your company commit to Tableau world.

Best Regards,

Bruno