2 Replies Latest reply on Jan 28, 2019 4:31 AM by Tharshan Sivapalan

    Data manipulation in tableau

    Tharshan Sivapalan

      Hi all,


      I was hoping if someone could help me with a task that I've been given.


      My data is as follows:

      As you can see Andy specified his location as North London in 2018. My task is to change his location in 2016 and 2017 from London to North London.


      My approach was to create two parameters and write the following formula:


      Even though this formula works for Andy, it effects James in 2017 (the NewLocation should've remained as London).


      Thank you in advance!