title: SSRS Lookup Based on Multiple Conditions
body: <p>I have a dataset (Volume) looks like this:</p>
  
  <p><a href="https://i.stack.imgur.com/HhzIc.png" rel="noreferrer"><img src="https://i.stack.imgur.com/HhzIc.png" alt="enter image description here"></a></p>
  
  <p>In my report, what I want to get is this: </p>
  
  <p><a href="https://i.stack.imgur.com/nd6HP.png" rel="noreferrer"><img src="https://i.stack.imgur.com/nd6HP.png" alt="enter image description here"></a> </p>
  
  <p>The Lookup expression: =Lookup (Fields!Id.Value, Fields!Id.Value,      Fields!Volume.Value,"Volume") can only lookup on ID. Is there any way I can do lookup on ID first, and then lookup on Sub_Group to get the correct Volume? Thank you.</p>