i'm not sure if i got this right or not, but by moving from a blending of 2 data sources to a left join into one data source the calculation becomes straight forward.
I dont know if your sources are mixed or the same (i.e sql, excel or both excel etc.).
If mixed then blending is the only way for now, and the calculation will struggle due to the need to aggregate across the join, i would say just be patient and tableau 10 will fix this for you, but don't know your deadlines (or your organisation's upgrade plans).
211606JH.twbx 978.1 KB
Thank you very much, this worked great.
Another case of overthinking the issue at hand. I greatly appreciate the help.
no problem Josh,
glad i could help, remember to mark the answer as correct so that this thread is set to answered.