KNOWLEDGE BASE

Change to Data Type of Field Used in Pivot Reverts When Workbook is Reopened


Published: 11 May 2017
Last Modified Date: 03 Jan 2018

Issue

When changing the datatype of a field which is used in a pivot, for example when self-joining two tables, the change to the datatype may not be preserved when the workbook is saved. When the workbook is reopened, the field has reverted to its previous datatype.

Environment

  • Tableau Desktop 
  • Excel

Resolution

Change data type prior to pivoting field. 
Did this article resolve the issue?