This content has been marked as final. Show 2 replies
I have the area chart below (fixed to a quarter) - the running totals are working fine (blue and orange) - however the target which is on a secondary datasource and is set for the quarter as a whole. One value of 66 for the quarter
Green represents Variance to Target
The blue and orange should chip away at the green over time (running total)
The green (Variance to Target) should be fixed for the quarter at 66
Variance to Target =
ATTR([BranchNameGroup (BranchGroupTargets)].[New Customers])-RUNNING_SUM(SUM([Is Newly Active]))
How do I get the Variance To Target to reduce by the Running Total table calculation at that date?