3 Replies Latest reply on Oct 20, 2018 1:04 PM by Balaji Subramani

# Percent of Total Distribution For Measure Value

Hi Tableau professionals,

I'm facing problem to get percentage of total distribution for the measure values in a report. The measure values not having quick table calculations to select percent of total like some other measures. I want achieve this to give desire output for the users. I could not share the workbook as it has important information

Example scenario is I have 5 measure Measure 1,Measure 2,Measure 3,Measure 4,Measure 5 on measure values

My calculation is like  measure 1, measure 2 = measure 1 - measure 2, measure 3= measure 2- measure 3,etc

I need percentage distribution like measure 1 - 100 %, measure 2 - 80%, measure 3 - 55%etc,. Any help is appreciated

• ###### 1. Re: Percent of Total Distribution For Measure Value

Hi Subramani,

Measure values is not a complete measure, it a combination of measure in your case it measure 1 to measure 5. So the quick table calculations will not be present.

To solve this you have to create percent of total for each measure separately first as calculated fields

Measure 1 - 100

Measure 2 - Measure 2/ Measure 1 = 80%

Like way, create calculated field for all five measures. Then use the calculated fields into "Annotations" on top of the bar charts (example chart)

Then format each annotation to remove all lines, arrows and borders and place on top of each bars on your measure values. Now the report will look like having percentage distribution for all measure values.

Hope this should solve your problem. Try it out and respond if it doesnt work for you!

1 of 1 people found this helpful
• ###### 2. Re: Percent of Total Distribution For Measure Value

Hi Balaji,

Help is bountiful here, but we need a workbook to play with.

Thanks

Deepak

• ###### 3. Re: Percent of Total Distribution For Measure Value

Hi Akram,

Thanks for your solution it worked. Is there any other way to do this please respond but somehow I got the solution. Thanks again !!