Forum Discussion
Create column containing average value for product and deviation for each row
Hi,
I have a table containing productcode and achieved price for each sale (row).
Now I want to calculate the difference from the average sale for the actual product on each row, like this:
| Product | Achieved price | Diff from average price |
| A | 50 | -8,333 |
| A | 60 | 1,666 |
| A | 65 | 6,666 |
| B | 187 | -2,500 |
| B | 192 | 2,500 |
| C |
And there are about 30000 sales and 50 products in the current table.
I've tried some combinations of AVERAGE (would prefer MEDIAN though) but I just don't get how to filter on products...
Anyone?
Regards,
John
1 Reply
Hi,
The information provided is incomplete. please try to give full context and input data and expected output along with calculation logic. this will help anyone to provide the solution.
