I am trying to compute Total Employees that are White, Black, Indian, etc by an ORG Code. The ORG Code for Admin would be 0010. I have attached an example of what I am trying to do. I have 1 Black Male and 3 White Males and 3 White Females. I need a Total Field to give me under Total Employees 6 Whites and 1 Black. I have the View just about done, but I just do not know how to make the computer count TotalEmp. See Example:
My Coding: SELECT HORGCD, COUNT(*) AS TotalEmp, [long-name], SEX
FROM dbo.['ABC TOTALS BY RACE AND ORG WITH$']
GROUP BY HORGCD, [long-name], SEX
Any help would be appreciated.
md092686
My Coding: SELECT HORGCD, COUNT(*) AS TotalEmp, [long-name], SEX
FROM dbo.['ABC TOTALS BY RACE AND ORG WITH$']
GROUP BY HORGCD, [long-name], SEX
Any help would be appreciated.
md092686