1 of 1 people found this helpful
pretty difficult providing a detailed response without see the workbook and data (see the link Anonymize your Tableau Package Data for Sharing )
but conceptually you have a couple of issues first the match on division - I don't think you will be able to split the Div out of the div name coming from SQL but you can concatenate it onto the one coming from excel - then you can deal with the different level of detail in you raw data using avg(), Min(), Max() as appropriate in the data that is already at a higher level
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.