6 Replies Latest reply on Aug 29, 2017 8:11 PM by DNK

    Custom Calculation in Pivot table

    DNK
      Codesumalternate Sum

      xyz

      514(Sum (abc+pqr))
      abc811(Sum(xyz+pqr)
      pqr613(Sum(xyz+abc))

       

      Hello Friends,

       

      I have a pivot table like above. Now I need to calculate the Alternate Sum for the above table in the following way

       

      for the Code xyz Alternate Sum = Sum(abc+pqr+.....)

      for the code abc Alternate Sum=Sum(xyz+pqr+.....)

      for the code pqr Alternate Sum= Sum(xyz + abc+.....)

       

      There may be additional Codes as well in the Code field.

       

      Thanks for your help.

       

      DNK