SSRS Lookup Based on Multiple Conditions : <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>
