Hi all, I'd like to compare each single value of my resultset to the average value for that resultset, can you plase help me?
I'd like to get something like:
Vendor | Order No |Order Amount| Deviation from average ord
1 |10 |5 |-1
1 |20 |7 |+1
|Total: |6 |0