Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!

Alteryx Designer Desktop Discussions

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

Alteryx window function?

ryanzhang487
8 - Asteroid

HI community,

I would want to create a column to show the sum of amount when department = "pension", and post it all along the dataset, (see the picture, it is similar to window function in SQL)

How can I do that please?

Thank you for helping

 

 

Screenshot 2023-02-04 021125.png

4 REPLIES 4
ShankerV
17 - Castor

Hi @ryanzhang487 

 

One way of doing this!!!!

 

ShankerV_0-1675496895083.png

 

 

Many thanks

Shanker V

Emmanuel_G
13 - Pulsar

@ryanzhang487 

 

Find in attachement the way of doing that. You display sum of values depending on current department.

 

Let me know if it works as you want please. ðŸ˜‰

 

Emmanuel_G_0-1675509857735.png

 

ryanzhang487
8 - Asteroid

is there a way to show "pension" sum on the for the apple too? basically I would want the sum of pension to be in all the rows

ryanzhang487
8 - Asteroid

yes that works, thanks

Labels
Top Solution Authors