KNOWLEDGE BASE

Unable to Reference a Value from Another Worksheet


Published: 12 Nov 2015
Last Modified Date: 29 May 2018

Issue

Unable to reference a value from another worksheet. For example, if the original worksheet uses filters to get the final value, or if the original worksheet is structured to get the correct results with a table calculation.

Environment

Tableau Desktop

Resolution

Create a calculated field that returns the same results without the filters. For instructions, please see Including Filters in Calculations Without Including them on the Filter Card

If the original view used table calculations, then the new view will have to include all of the dimensions necessary to compute the table calculation. In some cases, the new view can be reformatted to look like the additional dimensions were not added. For instructions, please see Computing a Table Calculation by a Dimension Not Present in the View

Cause

Currently the ability to reference values from another worksheet is not built into Tableau Desktop
Did this article resolve the issue?