Add up certain invoices

Question

Hi i have a simple question but i'm new to alteryx so i could need some help:

I would like to essentially add up all the available invoices for a specific invoice number (see attachment). The result should be a pivot table practically. 
Does anyone have a solution for this?

InvoiceTest.xls

binu_acs · Accepted Answer

@Christian1998 One way
 of doing this

gawa · Accepted Answer

hi @Christian1998

I suggest 2 solutions to realize your demand. I guess Solution 2 is preferable and easy to understand.