KNOWLEDGE BASE

Calculating Percent Difference Between Two Measures


Published: 03 Dec 2013
Last Modified Date: 16 Oct 2017

Question

How to calculate the percent difference between two separate measures.

Environment

Tableau Desktop

Answer

Create a calculated field similar to the following:
(SUM([Measure 1]) - SUM([Measure 2])) / (SUM([Measure 1]))

Then, format the new calculated field in Percentage. For more information, see Format Numbers and Null Values.
Did this article resolve the issue?