6 Replies Latest reply on Aug 14, 2019 5:34 AM by Vipul Khandelwal

    Normalize Total based on Category selection

    Vipul Khandelwal

      Hi there,

       

      i have a  Data Set and then categorized in following view :

       

         

      Type 1Value%  of Total
      A     10,971 2%
      B       4,011 1%
      C     32,481 5%
      D   111,909 19%
      E   129,383 22%
      F     72,308 12%
      G   222,423 37%
      H     16,611 3%
      Grand Total  600,097 100%

       

      Requirement is to normalize this data based on selection from column "Type 1" . For an example if i remove values for G or for D and G together distribution should look like this way :

       

        

      Type 1Value
      A     17,432
      B       6,373
      C     51,610
      D   177,815
      E   205,580
      F   114,892
      H     26,394
      Grand Total  600,097

       

        

      Type 1Value
      A     24,773
      B       9,057
      C     73,342
      E   292,147
      F   163,271
      H     37,508
      Grand Total  600,097

       

      please suggest.