KNOWLEDGE BASE

Month Over Month Difference As a Percentage


Published: 28 Apr 2014
Last Modified Date: 23 Dec 2016

Question

How to create a view showing month over month difference as a percentage.

Environment

Tableau Desktop

Answer

The following instructions can be reviewed in the attached sample workbook.
  1. In Tableau Desktop, connect to Superstore sample data.
  2. Drag Order Date to the Rows shelf.
  3. Drill down from YEAR(Order Date) to QUARTER(Order Date) to MONTH(Order Date). Then remove QUARTER(Order Date) from the view so that only YEAR(Order Date) and MONTH(Order Date) remain.
  4. Drag Profit to the Text card.
  5. Right-click Profit on the Text card, and then select Quick Table Calculation > Year over Year Growth.
  6. Right-click Profit on the Text card, and select Edit Table Calculation.
  7. In the At the level drop-down menu, select Month of Order date, and then click OK.

To view these steps in action, see the video below:
Did this article resolve the issue?