Counting of Rows on Same Values

Hi,

I have 2 tables Employee and Task. Each Employee has many Tasks and those Tasks are defined weekly.

In the Task Table I am trying to capture the count of the tasks by Employee Name+Week Number+Colour. So if an Employee has multiple tasks which results in the example like below.

Row 1 Gunsham Lakhiani-14-Green
Row 2 Gunsham Lakhiani-14-Green

This should be counted as 2 which is what i am trying to achieve by adding a column of Total Count which results in to 2 in each row.

I would like to have the count 2 only in one row and not in the second row after which I want to just dump Employee Name,Color,Week Number and Total Count into some other table where the Total Count is not blank for certain calculations.

Pl check the excel attachment or the Image below for your reference with the QB Ouput and the Desired Output.

Regards
Gunsham
9821258653




------------------------------
Gunsham Lakhiani
------------------------------