We have data in 3 different excel tabs in the same workbook. How can we calculate the variance in Tableau while reading values from each of the 3 tabs in the excel workbook? We are trying to calculate the variance by subtracting the data on the tab named "2017 Current Otlk Actuals" from the data on the "2017 Prior Otlk Actuals." We are using the pivot feature on all month names to make them a single column.
add each sheet to your data source, join and then create the variance in tableau