3 Replies Latest reply on Sep 24, 2018 8:57 AM by Shinichiro Murakami

    % of Total Diff

    Jess Lee

      Hi,

       

      I try to calculate the difference between % of total for 2 diff month at total level.  I always get 0%.  I attached my package workbook. 

       

      Here is the result i would like to see

       

         

      for 201709
      Count% of TotalDelta
      BRAZIL11440.57%0.01%<== 0.22 + (-1.04) + (-0.16) +1.37 + (-0.38)
      MEXICO16759.43%-0.01%
      Total281100.00%0.00%

       

      I just put 1 month as an example.  Of course i would like to see the result for other months as well

       

      Thank you,