6 Replies Latest reply on Jul 9, 2018 12:57 AM by Sally Safa

    Concentration Percentages for variable measures

    Sally Safa

      Hello Tableau Community,

       

      I am working on a set of data where I have multiple locations and groups within each, for each group I got the sum of utilized USD and the grand total of utilized USD per location, as shown below:

       

      Is there a way where I can calculate the concentration percentage for each Group reference? i.e. (sum(utilized USD) per group divided by the grand total of the same location the group belongs to)*100?

       

      I am new to table calculations and not sure if this can be done, appreciate any support

       

      I am using Tableau Desktop version 2018.1.

       

      Thanks in advance!

      SaL