1 Reply Latest reply on Apr 11, 2018 3:13 PM by Patrick Van Der Hyde

# Calculations between two sheets

I have, in Sheet1, filtered year (2017) and filtered quarter (Q4 from 2017).

In Sheet2, I have filtered year (2018) and quarter (Q1 from 2018).

Picture below as an example.

Now, I need to calculated difference between last value from Sheet2 and the value from Sheet1.

This means I need: 94.000-100.000

44.000- 50.000

8.000-   5.000

I don't know how to "connect" two sheets in calculation.

Thank you in advance. • ###### 1. Re: Calculations between two sheets

Hello Mila,

Do you have a sample workbook to share?  The two sheets of an excel workbook will appear as tables in Tableau.  The linking value here for a Join appears to be the field [Div]  but to determine what's possible we need to see how dates are represented in the data.  is the data really just the text Q1 and Q4?  If so, then a calculated field will be needed to turn these into dates.

Providing a workbook with the sample data would help to assist you.

Packaged workbooks: when, why, how

Thank you

Patrick