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
Hi @ryanzhang487
One way of doing this!!!!
Many thanks
Shanker V
@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. 😉
yes that works, thanks
