how to make column calculations in tableau with different excel sheets?

Question

Hello i want to make a difference calculations betwee excel sheets in Tableau, the sheets are years values so i have 2019 and 2020. 2019 is the column1 and 2020 column2

i have a column1 with number data and column2 with number data. some data are extra so i need to join the data for avoid that but look that doesnt work in Tableau. i want to make that every value of the column2 subtract with column1 be dimensions values. like [column2] - [column1] and in this way have a new dimension the difference between columns.

question from:https://stackoverflow.com/questions/65900846/how-to-make-column-calculations-in-tableau-with-different-excel-sheets

Answer 1

Waitting for answers