Hi All

What I need is to have a calculated column formula with the results as in a Table 1. (Calculated Column)

Results are MAX (Table 2. (Day))

Results are manually filled up, but in case of thousand of rows it is not possible.

Table 1. and Table 2. are not related one. But even if I relate them using addtitional table without duplicates i still can not look up properly. I have tried RELATED but it was not work.

**How the calculated table formula should look like?**

Table 1.

Week Produkt Calculated
column

1 A
new formula (result should be 3)

1 B
new formula (result should be 3)

2 c new formula
(result should be 2)

3 A
new formula (result should be 5)

Table 2.

Week Day

1 1

1 2

1 3

2 2

3 3

3 5