4 Replies Latest reply on Mar 12, 2017 10:53 PM by Mahfooj Khan

    Sum of Percentage value

    Abhijeet Bijoor

      Hi,

       

      I have the below data.

      I am trying to calculate Mtr 1/ Mtr 2 for each row. Then arrive at the sum (485%) and average (121%) of individual Percentage values.

      My target is to get the figure 485% even if I remove Dim 1 from my chart.

       

      Below is the issue I am facing.

      1. Mtr 2 is from secondary data source (through data blending) hence I cannot apply LOD functions.

      2. When I remove Dim 1 from the chart, Tableau calculates 90/82 = 109% but I want 485 %

        

      DateDim 1Mtr 1Mtr 2Mtr 1 / Mtr 2
      3/8/2017A1101283.33%
      A22015133.33%
      A3153542.86%
      A44520225.00%
      Total 9082485%
      Average121%

       

      Is there a way to achieve the sum as 485% and average as 121% after removing Dim 1 from column shelf?