Skip to main content

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

5 answers
  1. Apr 17, 2015, 9:00 AM

    Hi Jo,

    Problem have been solved by Tableau support team

    Thanks anyway

    Best

    Alex

    De : Joe Oppelt

    Envoyé : jeudi 16 avril 2015 21:10

    À : You, Alexandre

    Objet : Re:  - Calculated field based on parent column

     

    Tableau Support Community <http://community.tableau.com/?et=watches.email.thread>

     

    Calculated field based on parent column

     

    reply from Joe Oppelt<http://community.tableau.com/people/joe.oppelt?et=watches.email.thread> in Forums - View the full discussion<http://community.tableau.com/message/355068?et=watches.email.thread#355068>

0/9000