# How do you find the percentage of two measures in tableau?

**Published on Aug 22, 2018**

- Select Analysis - Create Calculated Field.
- 2.Name the calculation.
- 3.In the formula field, create a calculated field similar to the following and click OK:
- Repeat steps 1-3 for each new percentage.
- Create a new worksheet to display the percentage measures.

Keeping this in view, how do you measure percentage in tableau?

First, point at the field in the **measure** shelf, right-click on it, select Field Properties, then select **the percent** number type and pick the number of decimal places you would like to display. That method defines a default data type for all uses of that **measure** in any worksheet.

**Option 1**

- Drag the first measure to Text on the Marks card.
- Double-click a second measure in the left-hand Measures pane.
- Tableau Desktop will automatically move both measures to the Measure Values card.

Also question is, how do you show percentages and numbers in tableau?

Right click on the Sales pill and you will see a menu appear, navigate to 'Quick table calculation', where you will see a list of different table calculations. Next, click on **Percent** of total. You'll see that the x axis changes from the value of Sales in £, to the **percentage** of Total Sales.

To **calculate percentages**, start by writing the number you want to turn into a **percentage** over the **total** value so you end up with a fraction. Then, turn the fraction into a decimal by dividing the top number by the bottom number. Finally, multiply the decimal by 100 to find the **percentage**.