Good Day. [image] I have this datatable where it consists a list of employees together with their Employee IDs, Positions, Hours Rendered, and assigned Project Number. I want to find the summation of hours per employee just like the image below. Can I use Filter DataTable activity? Or are there a…

Hi @Robert_Russell_Monsalud As suggested by @ppr , this can be achieved through LINQ. Please refer the below screenshot and workflow files ( From row In dt_Data Group row By k = row("Employee ID") Into grp = Group Select dt_Data.LoadDataRow(grp(0).ItemArray.Reverse.Skip(1).Reverse.Append(grp.Su…

Summation of Hours per Employee

Help Activities

ppr (Peter Preuss) June 27, 2022, 8:53am 2

we would group the data:

1 Like

Topic		Replies	Views
Group data table and sum values in different columns Activities excel	10	4841	June 10, 2022
Getting the sum of row for thousands of employees Activities excel , activities , question	7	811	July 10, 2022
Linq Query on Group By and Sum Activities datatable , excel , activities , question , linq	4	4323	May 13, 2021
Transferring of Hours Rendered from one sheet to another Activities excel , activities , question	8	882	July 7, 2022
Finding the total sum of 2 columns using LINQ Activities excel , activities , question	8	1218	July 18, 2022

Most Active Users - Yesterday
ashokkarale
MD_Farhan1
Ajay_Mishra
postwick
Dheerendra_vishwakarma
Anil_G
chandreshsinh.jadeja
Gautham_Pattabiraman
vrdabberu
aravindbalineni123
More details...

Summation of Hours per Employee

Related Topics