1 of 1 people found this helpful
Find my approach as reference below and stored in attached workbook version 10.0 located in the original thread
1. Transfered Target: SUM([Target (Headcount Dashboard_2.8.17)].[Target])
2. Lookup Target: lookup(([Transfered Target]),LAST())
3. % of real: sum([Actual])/[Lookup Target]
Exactly what I needed. Thank You Norbert!!!
Good evening Karen,
You are welcome. Thanks for the "Badges":)