let
Source = Table.NestedJoin(Table1, {"Kode"}, Table3, {"Kode"}, "Table3", JoinKind.LeftOuter),
#"Expanded Table3" = Table.ExpandTableColumn(Source, "Table3", {"Qty in pcs"}, {"Qty in pcs"}),
#"Inserted Multiplication" = Table.AddColumn(#"Expanded Table3", "Multiplication", each [#"Price/pcs"] * [Qty in pcs], Int64.Type),
#"Grouped Rows" = Table.Group(#"Inserted Multiplication", {"Group"}, {{"Quantity", each List.Sum([Qty in pcs]), type nullable number}, {"Price", each List.Sum([#"Price/pcs"]), type nullable number}})
in
#"Grouped Rows"
A | B | C | |
1 | Group | Quantity | Price |
2 | Fruit | 80 | 134 |
3 | Vegetable | 69 | 69 |
GREATTT...AMAZING ...Thank you so much..1] In "Total Recap Price" B5, formula copied down :
=SUMPRODUCT((price!$C$5:$C$10=A5)*price!$D$5:$D$10*qty!$D$5:$D$10)
2] In "Total Recap Quantity" F5, formula copied down :
=SUMIF(qty!C:C,E5,qty!D:D)
View attachment 70991
thank for support..but formula and result that i mean ..as bosco-yip (above) solutionsCheck if this is how you wish
Decio