14 Replies Latest reply: Apr 26, 2017 7:45 AM by Vineeth Pujari RSS

    Handling pourcentages in a pivot table

    omar bensalem

      Hi all, stalwar1 , vinieme12


      I have the following table :



      I'm using this expression:

      if(Dimensionality()=1, sum(Taux)/sum(total Taux),


      sum(Taux) /sum(total Taux) ))


      What I want is, when dimensionality()=2, to have sum(Taux) / sum(Taux) of the first dimension; the pourcentage of each plaque % its Type Materiel and not % Total


      How to achieve this? Thanks