How to center data into a new column but only for specific conditions based on other columns?

[#1]

Hi all,

I want to center my data. But the problem is I only want to adjust the data with an average of it's respective category. For example, see table below. What if in the "age adjusted" col, I want the age column data but subtracted by the average of only the age data that has the same "city" and "gender" category?

So each age for "san francisco" and "male" would be subtracted by average of 1,2,3 = 2. The formula for new col "center" will use the average including every age in the entire column, right? So that won't work for me..

Thanks!!

[#2]

The formula to use is

:Age - Col Mean( :Age, :City, :Gender )

The data table with the formula is attached

The Col Mean() formula is documented in the Scripting Index available under the Help pull down menu