KNOWLEDGE BASE

Year Over Year and Year To Date Quick Table Calculations are Unavailable


Published: 14 Aug 2014
Last Modified Date: 16 Sep 2016

Question

How to enable YOY Growth, YTD Total, and YTD Growth when using Quick Table Calculations.

Environment

Tableau Desktop

Answer

To enable the necessary Quick Table Calculations, you must do the following:
  1. Include a date field at the Year level.
  2. Include the same date field drilled down to Quarter or deeper.
To view these steps in action, see the video below: 

Additional Information

The necessary calculations are not enabled unless there are at least two levels of the date field being displayed and the highest level must be Year.
 
Did this article resolve the issue?