6 Replies Latest reply on Oct 31, 2018 6:55 AM by Tony Nguyen

    Variance of 2 columns of the same Measure

    Tony Nguyen

      Hello All,

       

      I'm new to Tableau and have been self teaching for about a week now. I have a good background from Excel. Anyhow I have a set of data that I can't seem to get a variance between the years. I've done some research online and on forums to no luck.

       

      I tried do some calculated fields to no avail. I was hoping someone can help me out here. I have added a snippet of the data. Thank you for taking the time to read this, any help would be much appreciated!

       

      Note - the data set is for 2017-2018, I know I can adjust that, but for whatever reason if I have that year range the "Make" column overlaps it, and covers a good portion of it.

       

      Is what I requested possible with the current setup? Once again thank you for any type of input!

       

      Cheers,

       

      Tony

       

      EDIT - I have converted the "Report Year" to be recognized as a Date instead of numbers