Using the aggregation function, I can choose to sum up all the values, but is it also possible to use a calculation to aggregate? So, for example: an employee ID pops up multiple times in my table. Instead of summing up their salary to one overall amount per employee ID (using an aggregation), I want to use an amount in one row to multiply with an amount in another row (where both share the same employee ID). How would I go about achieving this?
Using the aggregation function, I can choose to sum up all the values, but is it also possible to use a calculation to aggregate?
So, for example: an employee ID pops up multiple times in my table.
Instead of summing up their salary to one overall amount per employee ID (using an aggregation), I want to use an amount in one row to multiply with an amount in another row (where both share the same employee ID).
How would I go about achieving this?