Combine 2 Tables into with Sub Total

Dear All,

If I got 2 tables which are Invoice Table (Sheet "Invoice") & Payment Table (Sheet "Payment") and i want to combine those tables into one table as in Sheet "Resume" which have Sub Total by the Invoice Number, is it possible to do it by Pivot table or Power query?
Thank you in advance

Omega Boost

See attached file, I hope that it's what you need.
I used this code:

Please Login or Register  to view this content.

Regards,
Antonio