2 Replies Latest reply on Oct 29, 2018 8:50 AM by Mikey Michaels

    My data is ugly - HELP

    Mikey Michaels

      Hello All,

      I hope this message finds everyone well.

      Bc of this forum, I have made great progress in getting some UGLY data into Tableau! Please see the attached Excel document.

      You will see on row 3 there is a fiscal year (our fiscal year starts in October 2018), row 4 is a month, and row 2 there is either a statement that says:

           - Pre-Previous Year = row 3 (2018 - 2 years) = 2016

           - Previous Year = row 3 (2018 - 1 years) = 2017

           - Actuals =  row 3 = 2018

       

      I need to find a way to somehow incorporate the values in row 2, row 3, and row 4 into a date field. For instance, in cell E5, the date for this column would be Nov 2016. For T5, the date would be March 2017.

       

      I thank you for your time and assistance.

       

      Cheers,

      Mikey