KNOWLEDGE BASE

How to Use the Results of a Table Calculation in Another Worksheet (Other Workbook) Without Table Calculation Setting


Published: 27 Apr 2021
Last Modified Date: 28 Apr 2021

Question

How to show the result of table calculation in another worksheet (Other Workbook) as a normal measure without Table Calculation Settings.

User-added image

 

Environment

  • Tableau Desktop

Answer

The result of table calculation could be used as normal measures by copying the data and adding in the data source.

Steps are as follows:
1. Select data by [Worksheet] > [Copy] > [Data]
2. Move to [Data Source] Tab and press [Ctrl + V].
3. Set the relationship between the two data sources.

Please check the attached video and workbook for details.
Did this article resolve the issue?