When date matches week show in column

[Anonymous]

Hello all

This is a pic of my current table/matrix:

The customer is related to the orders table, orders is related to orderlines.

You see the columns "Mail, Document, Letter", "Phone", "Meeting", these are bools.

I need 2 additional bool columns ("offered" & "confirmed"), these two values are in the orderlines table as OfferDate & ConfirmationDate. When Orderline x from customer x has an offerdate in week no 1, i need to show that.

Expected result would be something like that:

Here is a sample file, i hope it helps.

https://drive.google.com/open?id=1n3dbqEXaOyZsP1wv1Qcdp22W8nwy2uUV

Many thanks.

[v-yuta-msft]

@Anonymous ,

From the snipshots you post, it seems like there's another logic in Week No 2, 3, and 4? Could you clarify more details about that?

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @v-yuta-msft 

I dont know what you mean, so far i know there is no other logic??

The pic with the expected result is just a sample of the columns i need.