This is a dashboard for comparing one company performance against the whole industry.
Is it possible to look up the industry value for the company in the second data source and based on that value choose what industry should it be compared against?
So ideally the calculation would look something like this:
in pseudo code :
SUM ( IF industry = vlookup(company in company-industry table) then VALUE END )
Short answer...yes. Can you post an example workbook with your data sources/dashboard structure?