@Somasundaram script solution is below
Data:
LOAD
Name,
"Delivery Name",
"Order Qty",
"Received Qty",
"Received Date"
FROM Source;
Left Join(Data)
Load Name,
"Delivery Name",
sum("Order Qty") as Total_Order_Qty
Resident Data
Group by Name,
"Delivery Name";
Final:
Load *,
RowNo() as Key,
dual(round(Accum_Received_Qty/Total_Order_Qty *100)&'%',round(Accum_Received_Qty/Total_Order_Qty *100)) as %reached;
Load *,
if(Name<>Previous(Name) or "Delivery Name" <> Previous("Delivery Name"),
"Received Qty", RangeSum(Peek('Accum_Received_Qty'),"Received Qty")) as Accum_Received_Qty
Resident Data
Order by Name,"Delivery Name","Received Date";
Drop Table Data;
Now create a table on front end like below
Dimension: Name, [Delivery Name]
Measure :
30% Reached
=min({<Key={"=[%reached]>=30"}>}[Received Date])
50% Reached
=min({<Key={"=[%reached]>=50"}>}[Received Date])
