20 Replies Latest reply: Apr 13, 2018 11:13 AM by Sunny Talwar RSS

    Sum in a pivot table

    Sebastián Martinez

      Hi, in a pivot table I have one field with values 1, 2 and 3.

      I want to divide one amount field by SUM(amount) when field value = 1, for each value (1,2,3).

       

      DescriptionTotals% Sales
      Sales1000100%
      Cost50050%
      Other Cost20020%

       

      Thanks in advance

       

      Sebastian