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개
  1. 2015년 4월 17일 오전 9:00

    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