Datatable, How to use GroupBy with SUM function

[Alsabbagh_Hussam]

Hello everyone,

i have this excel table i need to sum amounts in the column B by currency.
So that i get another table with consolidated amounts for each currency with the date and Characteristics numbers.

on the left side is the input table and in the right side the output table
Kind regards,
Hussam

[ppr (Peter Preuss)]

[HowTo] Overview on different options for grouping data and processing the groups

This HowTo introduces on the different options for grouping data from a datatable in order to process the grouped data. Introduction Grouping data and processing the grouped data is a common scenario e.g. when the grouped data is to aggregate like summing up, find maximum, get the average or concatening items. Lets have a look on following data: [grafik] A possible scenario could be: Create a report containing following information: the region code the sum of CaseCount per RegionCode t…