2 Replies Latest reply: Mar 30, 2018 5:52 AM by Petter Skjolden RSS

    How to make dynamic percentage calculation for each group on pivot

    kaan erisen

      Hi all,

       

      I want to show percentage %ofParentTotal for each group on pivot table. I can make it by checking dimensionality of cell and calculate the %ofParentTotal for each group.


      sum(VALUE)/

      Pick(Dimensionality()+1,

      sum(total VALUE),

      sum(total VALUE),

      sum(total <DIM1> VALUE),

      sum(total <DIM1,DIM2> VALUE),

      )

       

      ss.png


      but I need to calculate it without checking dimensionality. Actually, I don't want to edit the expression when any dimension is added. It is not effective


      Is there any way to achieve this?


      Thanks,