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
115 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
• 17,870 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
2,048 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
18 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
992 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,367 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
• 17,870 points
298 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
• 17,870 points
18 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
• 17,870 points
340 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
• 17,870 points
19 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
• 17,870 points
45 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
• 17,870 points
150 views