I have a tableau dashboard that looks like below
My objective is to do the below
a) Compute the % of "Oneill Ltd" (from product family column) that makes up the total sales including other product family values
b) I want to store that ratio output in a seperate calculated field.
When I tried the tableau inbuilt feature table calculation, it is computing the ratio for all rows (which I don't want). I want to now the ratio/percentage of "Oneill ltd" only
#Tableau #Trailhead #Tableau Desktop & Web Authoring #Tableau Public
Hi,
I may still not fully understand what you’re trying to achieve, but are the values shown in the Sample diagram what you’re referring to?
For checking purposes, I’ve displayed each value as well.
Since the processing is done with an LOD calculation, please be aware that if you need any filter operations, you’ll have to use a Context Filter.
<sample>
<calc>