5 Replies Latest reply: Sep 20, 2016 2:42 PM by Rafael Souza RSS

    Pivot Table Percentage

    Rafael Souza

      Hello Everyone, good afternoon, I mounted this Pivot Table:

      PivotTable.png

      But must group calculate the percentage for the subtotal indicated like this :

       

      Prod%
      00.00%
      00.00%
      00.00%
      00.00%
      12.08%
      36.25%
      714.58%
      918.75%
      2858.33%
      48100%

       

      These are my expressions :

      Prod: SUM(QTDMOT)

      %: QTDMOT/Sum(QTDMOT)

       

      They could assist me ?