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
2,777 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,010 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,230 points
10,165 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 in Tableau by Neha
• 6,260 points
28 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
451 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
10,928 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,010 points
7,032 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,010 points
9,732 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,010 points
8,257 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,010 points
234 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,010 points
304 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,010 points
7,687 views
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP