2 Replies Latest reply on Nov 9, 2016 7:04 PM by John Croft

    Area Chart with showing running total with targets fixed for period

    Vanessa Gray
    Vanessa Gray Nov 9, 2016 4:02 PM

      Hi,

       

      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?