Hi Amy, you won't really be able to use a LOD calculation here because a data blend can only give you aggregated values, and the secondary data source can't contribute to the level of detail of the sheet.
What version of Tableau are you using, and what kind of data source? If you can use Tableau 10, this will be pretty easy to solve with cross-database joins.
Also, do you have a packaged workbook you can share?
Thank you so much for the respond. I just updated to version 10. By using cross-database joins and fixed syntax i was able to get the expected outcome.
You're very welcome! If you wouldn't mind, could you please mark the reply as correct so this no longer shows up as unanswered? Thanks!