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 :

      Capture.PNG

       

      I'm using this expression:

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

      if(Dimensionality()=2,

      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