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
      Other Cost20020%


      Thanks in advance