KNOWLEDGE BASE

## Calculating Percent of Total for Measure Values

Published: 19 May 2014
Last Modified Date: 09 Jan 2019

### Question

How to calculate and display percent of total for fields on Measure Value.

Tableau Desktop

### Answer

Use the following steps to calculate the percent of total for the Sales Furniture, Sales Office Supplies, and Sales Technology measure fields:
1. Select Analysis > Create Calculated Field.
2. Name the calculation. In the example workbook, the calculation is named "Sales % Furniture".
3. In the formula field, create a calculated field similar to the following and click OK
`SUM( [Sales Furniture] ) / SUM( [Sales] )`
4. Repeat steps 1-3 for each new percentage.
5. Create a new worksheet to display the percentage measures. In the example workbook, this worksheet is named "%Measures".
6. Make a new dashboard (Dashboard > New) and drag the Measures and %Measures worksheets onto the view side by side.
To view these steps in action, see the video below:
Note: Video is silent.

### Additional Information

Measure Names cannot be referenced in calculated fields.

Discuss this article...
Did this article resolve the issue?