3 Replies Latest reply on Feb 8, 2018 7:20 PM by Mac Iwase

    Differences between Year - Calculated Fields

    Mac Iwase

      Hello,

      I am trying to create a specific visualization but confused on how to do it.

      What I would like to do is shown in the screenshot below.

      Sample for Tableau.png

       

      Basically I would like to have columns which show the sales, cost, actual difference for a certain year, another year and then the differences of those two years.

      I would like to do this all in one sheet if possible.

      I have tried a few ways but got confused and am now lost.

       

      I've attached a sample workbook - For this workbook, I'm using 'profit' measure (in workbook) in replacement of the 'cost' measure (screenshot above)

       

      Any help would be appreciated!
      Thank you!