SOLVED
Alteryx window function?
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
ryanzhang487
8 - Asteroid
‎02-03-2023
11:19 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
Labels:
- Labels:
- Workflow
4 REPLIES 4
ShankerV
17 - Castor
‎02-03-2023
11:48 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Emmanuel_G
13 - Pulsar
‎02-04-2023
03:25 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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. 😉
‎02-04-2023
08:23 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
‎02-04-2023
08:28 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
yes that works, thanks