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
80 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
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
• 15,620 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,220 points
1,715 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
17 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
777 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,220 points
1,127 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
• 15,620 points
201 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
• 15,620 points
14 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
• 15,620 points
217 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
• 15,620 points
14 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
• 15,620 points
42 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
• 15,620 points
103 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.