2 Replies Latest reply: Aug 30, 2012 9:21 AM by Tomer Kalimi RSS

    Percentage calculation in pivot for hierarchy display

      Hello all,

       

      I have a pivot table that display the hierarchy I’ve been created (thanks to the people here that help me to achieve that).

       

      What I’m trying to do is to calculate the % of users that continue to the next step base on the amount of users that participate in the previous step

       

      The table below illustrate what I have and what is my expected column for % calculatio

      So for every branch that I will open I will have the % calculation according to the previous step

       

       

      Gender

      Step1

      Step2

      Step3

      Step4

      Step5

      users

      expected

      unknown

      Responda

      Mulher

      Nenhuma

      - Pantene

      Nao

      61

      61/194

      Sim

      91

      91/194

      -

      194

      Total

      194

      - TRES-emme

       

      83

      83/833

      -Nenhuma

       

      334

      334/833

      -WellaProSeries

       

      50

      50/833

      -

       

      833

      Total

       

      833

      Total

       

       

      833

      Total

       

       

       

      833

      Total

       

       

       

       

      833

       

       

      I guess that set analysis will be my solution here but I could not understand how to do it.

       

      Any advice its highly appreciated.

      Tomer