2 Replies Latest reply on Oct 18, 2018 1:19 PM by Vinnie Ahuja

    How could I create separate columns for Current Year and Previous Year (Tableau 10.4 32 bit)

    Ildiko Ronai

      Dear Tableau Users,

       

      I have raw data where you can find in one single column 3 months "current year" (CY) and 3 months "previous year" (PY)

       

      YearMonthValueCY/PY
      20192100CY
      2019190CY
      20181280CY
      2018270PY
      2018160PY
      20171250PY

       

      How could I make two separate columns for CY and PY values in order to see the relevant months (201902 and 201802) in one row?

       

      DateCYPY
      20190210070
      2019019060
      2018128050

       

      It would be really great if you could have a solution for this issue.

      Until that I try to figure out by myself and I give you an update.

       

      Thank you for your help.

      Kind regards

      Ildi