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,

      Alex