1 Reply Latest reply on Jan 2, 2018 10:22 AM by Alan Perez

    Subtracting Data from 3 Different Sheets

    NAVYA KARNATI

      Hi All,

       

      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.