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
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>