2 Replies Latest reply: Mar 15, 2013 1:28 PM by Corrado Matcovich RSS

    Partial sum value in a pivot table

    Corrado Matcovich

      Hi everibody,

       

      I need an expression to calculate a partial percentage (percentage on a subtotal) in a pivot table like this:

       

      Dim1Dim2Sum(Value)SumTPartPerc
      AAA1617%
      AB2633%
      AC3650%
      Total6 100%
      BBA106017%
      BB206033%
      BC306050%
      Total60 100%
      Total 66

       

      I tried with this SumT expression:

       

      sum(aggr(sum(Value), Dim1))


      but the correct value (6 or 60) is shown only in some cells and not in all of them.

       

      Tanks for any suggestion!

       

      Corrado Matcovich