KNOWLEDGE BASE

Calculating Year over Year Growth with Individual Measures


Published: 28 Oct 2013
Last Modified Date: 12 Sep 2016

Question

How to calculate year-over-year growth when figures are individual measures. For example, in the formula below, Year 1 and Year 2 are separate measures.

Environment

Tableau Desktop

Answer

Create a calculated field with a formula similar to the following:
SUM([<Year 2>] - [<Year 1>])/ SUM([<Year 1>])
Did this article resolve the issue?