7 Replies Latest reply on Feb 17, 2020 7:18 AM by Alpha Beta

    Variance to baseline

    Alpha Beta

      I would like to compare providers line items (sales, CoGS, gross profit, EBITDA, operating profit) across providers A, B, C, D, and F to provider E, which serves as my baseline. I'd like to know the percentage difference regardless of year or whether or not I have companies in the view. Both sheet 1 and sheet 2 should show the variance.

       

      The result should look something like this:

       

      ProviderSalesCoGSEBITDA
      A10%5%20%
      B2%0%-3%
      C1%-1%4%
      D-6%-2%0%
      E
      F2%3%4%

       

      I'm not sure how to do this with table calculations. The "relative to" option does not let me select a specific row.

       

      I'm using Tableau 2018.1

       

      Thank you.