9 Replies Latest reply on May 15, 2018 12:38 PM by Deepak Rai

    Calculating a Dimension's Percent of Total based on the Dimension's value

    Richard Couillard

      Hi. I am a novice to Tableau and am sure there is probably a fairly simple way to do this but I keep going into a mental loop when trying to figure it out :-)

       

      • I have a Dimension called "Complexity". Possible values are "High" or "Low".
      • I have a graph that shows the number of projects per client, by complexity (High or Low).
      • I want to calculate the % of High complexity projects against the total number of projects .

       

      For example, I have 150 High Complexity projects out of a total of 210 (71%) but can't figure out the formula for this.

       

      I have attached a workbook that has a red tab called "Complexity" that I want to perform the calculation on.

       

      Thanks