Need to do a group by on department column and do the sum of total column and the out put should be placed in the next row

[vishal_nachankar (Visky)]

Hi All,

I am not able to get the expected output.
I have a datatable with all the rows now i need to do the group by on department column and get the sum of total column for that group by and the output should be placed in the next row .Please find the below screenshot for reference.Can anyone please help to solve the above problem

[vishal_nachankar (Visky)]

[vishal_nachankar (Visky)]

anyone can please help me

[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…

[vishal_nachankar (Visky)]

did u get my query i want the output as per the screenshot

[vishal_nachankar (Visky)]

Hi All i am attaching the input file and the required output file.
input.xls (29 KB)
output.xls (30.5 KB)

[vishal_nachankar (Visky)]

ANY SOLUTIONS GUYSS PLEASE