Calculated column by using group by other columns.

Thank you Anonymous and v-ljerr-msft for detailed reply,

But with the suggested solution from both of you I have following problem:

I am having 2 different table table 1 and table 2 which are connected to each other. and Name and date are coming from two different table.

Hours spent and date is from table 1

name is from table 2

Anonymous With earlier I am not able to use the other table's column.

v-ljerr-msft I don't know if there is a way to create a new calculated column which takes input from two different tables.

Thank.