3 Replies Latest reply on Apr 18, 2018 10:40 PM by Sankarmagesh Rajan

    Diverging Chart To Compare 2 different year sales in percent

    Divya Bhati

      Hi All,

       

      I am trying to make a diverging chart to compare sales of 2011 & 2012 in percentage by regions wise.

      I have created to separate calculations.

      Calculations

      1. 2011 sales > {FIXED  YEAR([Order Date])=2011 , [Region]: SUM([Sales])} (reversed the axis of 2011 to make diverging chart)

      2. 2012 sales > {FIXED  YEAR([Order Date])=2012 , [Region]: SUM([Sales])}

      then i added quick table calculations percent of total

      but result for both the years is coming wrong.

      For reference adding workbook.