11 Replies Latest reply on May 8, 2017 5:17 AM by Norbert Maijoor

    How can fix Other Amount to Prior Year/ Previous Year & USD to Current Year?

    Khalid Baker

      Hey Everyone;

       

      The analysis is comparing values of last year vs current year (Year is not fixed, so if you have data from 2014 -2017 than you would compare 2014-2015,2015-2016 & 2016-2017 by filter of course).  The conditions are as follows:

      1. PY (Prior Year) uses the Other Amount (Measure)
      2. CY (Current Year) uses the USD
      3. Comparison would be between prior year Other & Current Year USD as a bar chart (Growth %s using the previous logic)

       

      Appreciate all the help

       

       

      Kind Regards;

      Khalid