Sounds like LOD but would probably need to know more.
Lookup is forced to used the level of detail that is on the viz. So, by your first condition, you would have to have the lowest level of detail on the viz.
How you're presenting your data (What level of detail) is important for this question.
Do you have example workbook and some sort of mockup of what you want the end result to look like?
Thanks for response. here is a sample dataset (very dumbed down)
I would like to visualise a bar chart using a COUNTD on the shipment number (this shows the number of shipments our company has moved) with colour coding on the shipments showing % directly linked to a contract, or can be linked to a similar contract or there is no possible match.
DIRECT LINK is WHERE S.LANE_ID=R.LANE_ID at row level (I marked in green in the XLS)
SIMILAR LINK is WHERE S.LANE_ID = R.LANE_ID but match can be present anywhere in R.LANE_ID column (I marked in Orange in the XLS)
NO LINK is where S.LANE_ID does not have a match anywhere (I marked in grey in the XLS.)
Hope this makes sense?
Sample Data.xlsx 8.4 KB