Use values from output in different worksheets for a calculated field in Tableau

9.9k views Asked by At

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?

0

There are 0 answers