I want to sum employment numbers by skill...
Employment data is by occupation (technically, think State, Region, and County - say 800 occupations for each leave).
To this I join skills (there are 32 skills, an occupation can have multiple skills - so, if an occupation (say cashier) that has 3 skills (say, active listening, problem solving, and writing), now i have 3 rows for that occupation, for each of the areas [say, Cook County, EDR 4, Illinois] but only 3 employment numbers.
I want to add the employment, by area (say EDR 4) by skill.
what almost works is
SUM(
{
EXCLUDE [Knowledges]
:
MAX([BaseEmployment] )
}
)
this gives me employment for each occupation, but i can't seem to figure out how to sum to the skill...
the 1,076,112 is the number i need for this particular skill... there are 32 skills
SUM({
INCLUDE [SOCCode]
:
MEDIAN([BaseEmployment] )
}
)
// for each detailed skill, base year, area,
this seems to capture what i was getting at.. thank you for looking...
the visualization will not have the individual occupations... so, using Include pulls that in...
