5 Replies Latest reply on Feb 24, 2015 1:24 PM by Americo Guazzelli

    Custom months comparison

    Naike Nall

      I need help in comparing daily data for months in 2014 vs same month in 2015

      the challenge I have is:

      Month days are only working days (Mon-Fri)

      Month end is always the 4th working day of the next month

      I need 2 columns  2014-2015 and then the days on rows, the days are aligned by days left to go (to month end) descending

      so day one of the month is 24 for example and day last (month end) is zero, if the number of days are not the same they must be aligned to the 0 point...

       

      Can anyone help me  please???