Skip to Content
0
Former Member
Nov 08, 2005 at 04:18 PM

Different aggregation level comparison

23 Views

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