aggregating

[#1]

Hello all,

I have a problem if someone can help me with:

let us say i have the following table

City                    State     Value A

Houston               TX          10

Dallas                  TX           8

Belmont               CA          12

Mountain View     CA            6

now i have to use some formula where I compare the value at city level with average at State level, say

if value A for Houston (which is 10) is greater than average of state TX (which 9) then Value B 100.

I tried using aggr function but I think i am not able to use is correctly because if I do not give city as dimension, i only get calculation for one city and if I give city as dimension i obviously get average at the city level and not at state level.

thanks,

Manoj

[Saravanan_Desingh]

No words against Sunny

I agree..

[sunny_talwar]

You can always correct me if you think I am wrong. I will take your comment in a very sporty way my friend