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?