Hi
How can I sum in a calculated column (not in a calculated measure)
If I for instance have the following table
<tbody>
</tbody>
How do I make a Calculated Column that sums the total hours an employee as registered for the certain month. For instance EmployeeID 1 has registered a total of 18 hours for january 2015, so every row for employeeID 1 and a date in january 2015 should have 18 in this calculated column.
Like this:
<tbody>
</tbody>
How can I sum in a calculated column (not in a calculated measure)
If I for instance have the following table
EmployeeID | Date | HourRegistration |
1 | 01-01-2015 | 7 |
1 | 02-01-2015 | 5 |
1 | 03-01-2015 | 6 |
2 | 01-01-2015 | 3 |
2 | 02-01-2015 | 2 |
1 | 01-02-2015 | 7 |
1 | 02-02-2015 | 4 |
2 | 01-02-2015 | 3 |
2 | 02-02-2015 | 2 |
<tbody>
</tbody>
How do I make a Calculated Column that sums the total hours an employee as registered for the certain month. For instance EmployeeID 1 has registered a total of 18 hours for january 2015, so every row for employeeID 1 and a date in january 2015 should have 18 in this calculated column.
Like this:
EmployeeID | Date | HourRegistration | EmployeeMonthTotal |
1 | 01-01-2015 | 7 | 18 |
1 | 02-01-2015 | 5 | 18 |
1 | 03-01-2015 | 6 | 18 |
2 | 01-01-2015 | 3 | 5 |
2 | 02-01-2015 | 2 | 5 |
1 | 01-02-2015 | 7 | 11 |
1 | 02-02-2015 | 4 | 11 |
2 | 01-02-2015 | 3 | 5 |
2 | 02-02-2015 | 2 | 5 |
<tbody>
</tbody>