3 Replies Latest reply on Feb 22, 2016 2:10 PM by Roy Shim

    Creating dual axis measure value from stacked bar chart

    Roy Shim

      Hello all,

       

      I'm trying to create a target (or Plan) line as shown in my drawing below.

      I understand that it should probably be on a dual axis (secondary axis) and be defined as line type instead of bar.

      But I can't figure out how to create this calculated field...

      It needs to be the sum of Plan15 Fixed Cost, Plan15 Material Cost, and Plan15 Variable cost.

       

      I attached the packaged workbook. Any help would be greatly appreciated.

       

      2016-02-22_16h17_47.png