Calculate a measure based on the row value of a dimension

[tas_taba1]

Hello Qlikkers,

I have a dataset with fields like PersonID, CinemaStratum, CinemaPSU, TraumaWt, Sex, Race, Gender, etc. I want to create a straight table in QS that will calculate a measure for one of the Race field value African American. For this, I am looking for a way to calculate the column e.hij = y.hij – ybar (Please refer to the .xlsx attached) where ybar is the mean of sum for African American. To calculate the desired measure, I want to substract the mean of African American from the column y_hij which is basically an indicator for the Race type e.g. it will be 1 for African American rows and 0 for all the other row values. I am providing a screenshot of the table as well. The QS app (sheet 2) is also attached for reference.

Any help regarding this will be greatly appreciated. Thank you.