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

Sum of Percentage value

Abhijeet Bijoor Mar 8, 2017 4:48 AM

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 %

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

Mark Bradbourne Mar 8, 2017 4:57 AM (in response to Abhijeet Bijoor)
See the attached video on adding Totals to your table.

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

AddTotals.mp4 187.2 KB
Like Show 0 Likes(0)

Actions
2. Re: Sum of Percentage value

Mahfooj Khan Mar 8, 2017 5:02 AM (in response to Abhijeet Bijoor)

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
Like Show 0 Likes(0)

Actions
3. Re: Sum of Percentage value

Abhijeet Bijoor Mar 8, 2017 6:07 AM (in response to Mahfooj Khan)

Thanks Mahfooj for your reply.

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

Abhijeet
Like Show 0 Likes(0)

Actions
4. Re: Sum of Percentage value

Mahfooj Khan Mar 12, 2017 10:53 PM (in response to Abhijeet Bijoor)

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
Like Show 0 Likes(0)

Actions

Tableau Community Forums