Hi All Query objects can also perform calculations on data, such as finding the sum or average of all values in a column of the dataset. Business Central query objects enable you to retrieve records from one or more tables and then combine the data into rows and columns in a single dataset. As an … Continue reading
"
https://divyeshchittenavbc.wordpress.com/2020/01/28/how-to-join-data-items-to-define-the-query-dataset-in-microsoft-dynamics-365-business-central-msdyn365bc/