SSRS

Hello,

I have table1 that is using  dataset-A. I grouped this table by date. I have other dataset- B which contains total_qty column.

I have to sum this column(total_qty) and show the result in table1 under  every group total  .

Data set A columns:

Date

company_code

location_name

volumes

Data set B columns: 

Date

Company_code

Total_Qty

How can I get Sum(total_qty) from Dataset B into table1 under group total ?Also,total_Qty should change as it is placed in group?