Assign values from one level to next

[Karunya]

Hey Guys,

I am facing the below issue:

I have a table as shown below 

Unit	Measure	YearWeek	Employee	ValueType	Sum(Value)
100-1	Calls	2019-29	AA	Actuals	30
100-1	Calls	2019-29	AB	Actuals	20
100-1	Calls	2019-29	AC	Actuals	30
100-1	Calls	2019-29	-	Target	100

I have targets available at Unit level, which now have to be assigned to employees in that Unit.

Is there a way to do this using set analysis? 

Alternatively, is there a way to do the same using data load editor

Thanks in advance!

-Karunya

[sunny_talwar]

Actual will be 

Sum({<[Value Type] = {'Actual'}>}Value)

Forecast will be

If(Sum({<[Value Type] = {'Actual'}>}Value) <> 0, Sum(TOTAL <unit> {<[Value Type] = {'Forecast'}>}Value))

[Karunya]

Thank you very much Sunny!

I have never used Total before, could you explain the working of the formula in a sentence? 

[sunny_talwar]

See here

What does the TOTAL qualifier do?