4 Replies Latest reply on May 2, 2018 6:17 PM by Jane Wong

    Difference between a measure value and other two measure values

    Jane Wong


      I want to show how far away from sum of Sales to Target and sum of Sales to Bonus.


      e.g. For Australia, total sales is 1550, Target (orange Gantt bar) is 2300 and Bonus (blue Gantt bar) is 2800, so I want to show 750 under Orange Gantt Bar and 1250 under the blue Gantt Bar. Same way of calculation for other countries too.


      I tried (please see attached workbook) but both 750 and 1250 appear under both orange Gantt and blue Gantt bar.


      Many thanks