I would like tohave achart that displaysbackorders, but only forcustomerswho also havean orderfordeliverytomorrow.
I have those two table
Cod.Cus
CompanyName
001
Company1
002
Company2
003
Company3
004
Company4
005
Company5
006
Company6
007
Company7
008
Company8
009
Company9
010
Company10
011
Company11
012
Company12
013
Company13
014
Company14
015
Company15
016
Company16
017
Company17
018
Company18
019
Company19
ordN°
CodCus
CodArt.
DeliveryDateRequired
Qty
Price
Status
Ord001
Cus001
Art001
29/07/2013
1
10
Delivered
Ord001
Cus001
Art002
29/07/2013
2
12
pending
Ord001
Cus001
Art003
29/07/2013
4
9
pending
Ord002
Cus002
Art004
29/07/2013
1
3
Delivered
Ord003
Cus003
Art005
29/07/2013
2
78
pending
Ord004
Cus001
Art006
30/07/2013
1
12
Delivered
Ord005
Cus002
Art007
30/07/2013
3
15
Delivered
Ord005
Cus002
Art008
30/07/2013
12
12
Delivered
Ord005
Cus002
Art009
30/07/2013
3
1
pending
Ord010
Cus003
Art010
30/07/2013
1
43
pending
Ord011
Cus001
Art011
31/07/2013
3
23
Delivered
Ord011
Cus001
Art012
31/07/2013
1
54
Delivered
Ord012
Cus002
Art013
31/07/2013
4
12
Delivered
Ord012
Cus002
Art014
31/07/2013
2
1
Delivered
Ord013
Cus003
Art015
31/07/2013
3
3
pending
Ord016
Cus001
Art016
01/08/2013
1
4
pending
Ord016
Cus001
Art017
01/08/2013
7
5
pending
Ord017
Cus002
Art018
01/08/2013
4
1
pending
Ord017
Cus002
Art019
01/08/2013
1
323
pending
I would see only the order in status pending, but only of customers Cus001 and Cus002, because they have an order with DeliveryDateRequired tomorrow (today is 31-07-2013).
many thanks for you answer. Unfortunatelly this is not what I am looking for.
In your application you use this expression
=if(Date=date(Today()+1,'DD/MM/YYYY'),Status)
It show me the orders that I have to deliver tomorrow, but not the backorders of those customers .
If it is possible, I would see not only the orders I should deliver tomorrow, but also the back orders of the customers that have an order that it should be delivered tomorrow.
