2 Replies Latest reply on Apr 17, 2015 2:00 AM by Alexandre You

    Calculated field based on parent column

    Alexandre You

      Hello Tableau community,


      I am trying to create a calculated field

      I would like to make the sub-total) a reference for my calculation (like when calculating a market share).



      In the example attached, in the column "EI", The calculation I would like to do is:


      1) ("growth of Meflosyl" * 100+100)/("growth of sub-total" * 100+100)

      2) ("growth of Rimadyl INJ Cattle" * 100+100)/("growth of sub-total" * 100+100)

      3) And so on for every product


      In other words, I would like to make the total of the parent column as the divisor.


      Do you think it is possible?


      Thanks in advance and best regards,