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, 2019 in Tableau by sindhu
4,241 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, 2019 by Cherukuri
• 33,030 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
11,597 views
0 votes
1 answer

Showing absolute and percentage values in Tableau

I recreated a data like yours, Follow these ...READ MORE

answered Apr 5, 2022 in Tableau by Neha
• 9,060 points
4,168 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,820 points
1,231 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
15,242 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, 2019 in Tableau by Cherukuri
• 33,030 points
21,024 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, 2019 in Tableau by Cherukuri
• 33,030 points
15,745 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, 2019 in Tableau by Cherukuri
• 33,030 points
11,509 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, 2019 in Tableau by Cherukuri
• 33,030 points
933 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, 2019 in Tableau by Cherukuri
• 33,030 points
1,108 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, 2019 in Tableau by Cherukuri
• 33,030 points
10,600 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP