I have two worksheets, each with the same variable but with different filters working on that variable in each worksheet.
For example:
In worksheet 1: [Run/100] = 2.1
In worksheet 2, with filters applied: [Run/100] = 4.0
What I would like to do is create a calculated field that takes the current value of [Run/100] in worksheet 1 and divides it by the current value of [Run/100] in worksheet 2. I have searched around, but can't seem to find anything on referencing worksheet values in Tableau.
Does anyone know of a way to do this?