2 Replies Latest reply on May 18, 2018 5:37 AM by sudheer.kumar.5

    PY Difference %

    Sebastian Thierfelder

      Hi Tableau peeps,

       

      Probably a quite basic one here:

       

      I have 2 dimensions - Sales & Date (which includes years, months, weeks, days)

      What I want to show is the difference of 2017 Sales vs 2018 Sales. Ideally I'd have a table on which I can see Sales for both years and as a third row/column their difference in percentage.

       

      It would be quite easy if my Sales for both years were 2 distinct dimensions, but in this case they're not.

      I assume a calculation is needed, in which I have to somehow attribute 2017 Sales to 2017, and same for 2018...

       

      Any help is mucho mucho appreciato!!
      Seb