Alteryx window function?

[ryanzhang487]

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

[ShankerV · Accepted solution]

Hi @ryanzhang487 

One way of doing this!!!!

Many thanks

Shanker V

[Emmanuel_G]

@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. 😉

[ryanzhang487]

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]

yes that works, thanks