4 Replies Latest reply on Oct 26, 2018 2:10 PM by Eugene Trilesnik

    How to Average and then use the results in another calculation

    Eugene Trilesnik

      Hey Guys,

       

      I have a file that looks kind of like the one I attached. The goal I need to do is Use the Difference tabs, average them over 3 years, and then add the variance row to it. I have been trying to figure it out but I have not come close. I was wondering if you guys can take a look and see if there is something im missing. Attached is the Excel and Tableau workbook. In Tableau, I pivot all the rows after account as you will see. Please let me know if there is something I can do or somehow I can learn.

       

      Best,

      Eugene