Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Add up certain invoices

Christian1998
5 - Atom

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? 

3 REPLIES 3
binuacs
21 - Polaris

@Christian1998 One wayimage.png of doing this

 

gawa
16 - Nebula
16 - Nebula

hi @Christian1998 

 

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

image.png

Christian1998
5 - Atom

hi guys, thank for help, its working. 

Polls
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!
Labels