Rank measure values and show percentage of measures in Tableau

0 votes
Hi, i want to find the order of countries with highest profit and show all other measure values in percentage contribution of sales, orders and discounts. Can someone help me do this.
Mar 8 in Tableau by sindhu
312 views

1 answer to this question.

0 votes

Hi Sindhu,

1. First create a table with Profit, Sales, and the other measures you want.

2. Right click on Profit pill and go to quick table calculation and select rank, then the profit is shown in terms of rank below. 

3. Similarly right click on the sales pill and go to quick table calculation and click on percent of total.

4. Similarly add all the measures required and convert them to percentages. (shown as below)

Hope this helps you.

answered Mar 8 by Cherukuri
• 26,880 points

Related Questions In Tableau

0 votes
1 answer

How to count occurrence of value and percentage of a subset in tableau public?

Although it sounds like a fairly easy ...READ MORE

answered Jun 5, 2018 in Tableau by Atul
• 10,240 points
3,135 views
0 votes
1 answer

Measures and dimensions in Tableau

It is basically categorical and quantitative data. ...READ MORE

answered Apr 27, 2018 in Tableau by QueenBee
• 1,810 points
38 views
0 votes
1 answer

How to get multiple Sets of Measure Names with different Filters on a single sheet in Tableau?

The easiest solution to your query is: 1) ...READ MORE

answered Aug 23, 2018 in Tableau by Naruto
• 710 points
1,582 views
0 votes
1 answer

How to color code cells of a column based on the text value in Tableau

You can use the following steps to ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,240 points
1,987 views
0 votes
1 answer

Tableau- Pie Chart with Multiple Measure Values

Hi Nithin, Pie chart is used to show ...READ MORE

answered Mar 11 in Tableau by Cherukuri
• 26,880 points
624 views
0 votes
1 answer

Display Percentage in a Row in Tableau

Hi Sindhu, You can follow below steps: 1. Create ...READ MORE

answered Mar 13 in Tableau by Cherukuri
• 26,880 points
39 views
0 votes
1 answer

How to show percentages on the slices in pie chart in Tableau?

Hi sindhu, You can manually move the labels ...READ MORE

answered Mar 13 in Tableau by Cherukuri
• 26,880 points
926 views
0 votes
1 answer

How to calculate work done for a given date or period of time?

Hi, Follow these steps: As per you question since ...READ MORE

answered Apr 1 in Tableau by Cherukuri
• 26,880 points
26 views
0 votes
1 answer

Search values in a sheet for a field and display in tableau

Hi Sindhu, Follow below steps: 1. Create a parameter ...READ MORE

answered Apr 3 in Tableau by Cherukuri
• 26,880 points
53 views
0 votes
1 answer

How to sort by any measure in a Tableau table?

Hi Sindhu, Once you have created a bar ...READ MORE

answered Mar 8 in Tableau by Cherukuri
• 26,880 points
507 views