3 Replies Latest reply on Sep 28, 2018 1:23 PM by Hari Ankem

    Calculate Variance from inner column

    Eugene Trilesnik

      Hey guys,

       

      I have a test data file attached. My goal is to get the variance for a specific column between years. All the years are in 1 column. The goal is to get the variance between 16-17, and 17-18. My real data set has many many columns and many rows so this is just simplified. Is there a way I can do this in tableau with custom calculations. The end goal is a year over year  variance bar graph. Thank you.

       

      Best,

      Eugene