Count of Missing orders

[Vinni2000]

I need to show count of un delivered  orders in KPI , so here confusion is in one order we may have multiple items , in data we have data for all the items with different delivery number so here I how to show count of  un delivered orders "not at item level" so here in order we have multiple items and delivered only one item then also we need to consider that as delivered 

[Kushal_Chawda]

@Vinni2000  How to identify that Order is delivered? What is condition?

[Vinni2000]

Here we have orders table , item table and delivery table . In orders table we have information like order number and order date in item table we have item details of particular order and in delivery table we have delivery information of all the items . So here we have to join all the table by using order number and left outer join. So here if we deliver one item from the order we need to consider that order is delivered . Means we are building dashboard at order level not at item level