Add up certain invoices

[Christian1998]

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? 

[binu_acs · Accepted solution]

@Christian1998 One way of doing this

[gawa · Accepted solution]

hi @Christian1998 

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

[Christian1998]

hi guys, thank for help, its working.