4 Replies Latest reply on May 24, 2017 11:16 PM by Khalid Baker

    How do I assign USD Amount to Current Year & Other Amount to Previous Year?

    Khalid Baker

      Hey Everyone;

       

       

      I am trying to create a formula where whenever I select any 2 years (2013 & 2014 or 2014 & 2015 or 2015 & 2016), the latest year or current year would be in USD Amount (Measure 1) and prior year as Other Amount (Measure 2). (They are both different measures) (Date (Year) as filter or parameter)

       

      For Example:

      Suppose I selected 2015 & 2016 than 2015 is Other Amount & 2016 is USD Amount. Then I decided  to select 2014 & 2015 than 2014 is Other Amount & 2015 is USD Amount.

       

      Hope anyone can assist me with this!

       

      Kind Regards;

      Khalid B