Search SSRS based on multiple conditions

Question

I have a dataset (Tom) as follows:

In my report, I want to get the following:

expression Lookup: = Lookup (Fields! Id.Value, Fields! Id.Value, Fields! Volume.Value, "Volume") can only search for an identifier. Is there a way by which I can first search by id and then search in Sub_Group to get the correct volume? Thanks.

Answer 1

You can Lookup use several fields if you combine all the necessary fields in the first and second Lookup parameters.

 =Lookup(Fields!ID.Value & Fields!SUB_GROUP.Value, Fields!ID.Value & Fields!SUB_GROUP.Value, Fields!VOLUME.Value, "Volume") 

Alternatively, you can combine all the required fields in your dataset and use them for Lookup .