Hi,
I have created a query for broadcast purpose with u2018MATERIALu2019 in rows and the following columns:
Order Quantity
Delivery Quantity
Order Value
Total Service Level % - i.e. 100 + ((Under delivered Qty / Order Quantity) * 100)
I need to add another column to display the cumulative % with the starting point being the date before the delivery. How do I go about implementing this?
Thanks,
Milind