Unable to Reference a Value from Another Worksheet

Published: 12 Nov 2015
Last Modified Date: 08 Jan 2019


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.


Tableau Desktop


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


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