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

# Sum of Percentage value

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 %

 Date Dim 1 Mtr 1 Mtr 2 Mtr 1 / Mtr 2 3/8/2017 A1 10 12 83.33% A2 20 15 133.33% A3 15 35 42.86% A4 45 20 225.00% Total 90 82 485% Average 121%

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

• ###### 1. Re: Sum of Percentage value

For the Average, duplicate your Mtr 1/ Mtr 2 measure and set the default aggregation to Average.

• ###### 2. Re: Sum of Percentage value

Hi Abhijeet,

Try this,

Grand Total %:

{FIXED [Date],[Dim 1]:SUM([Mtr1])}/

{FIXED [Date],[Dim 1]:SUM([Mtr2])}

Only change the aggregation level.

SUM() from Grand total % And AVG() for Average Total %

Mahfooj

• ###### 3. Re: Sum of Percentage value

But my Mtr 2 comes from a different data source hence Tableau doesnt allow me use the LOD functions (FIXED)

Abhijeet

• ###### 4. Re: Sum of Percentage value

It'll be more helpful for us If you share some mock up data either in crosstab (excel,csv,text) or packaged workbook (.twbx).

Mahfooj