3 Replies Latest reply: Feb 26, 2015 4:02 AM by James Green RSS

    Lookup corresponding field value in UI

    James Green

      Hi all

       

      I have a calendar table that contains each calendar date for a chosen period and it also includes lookup fields like Year, Month and a concatenation of Month and Year.

       

      CalendarDateCalendarYearCalendarMonthMonthYearMonthYearSeq
      01/02/20152015FebruaryFeb-20152
      02/02/20152015FebruaryFeb-20152
      01/03/20152015MarchMar-20153
      01/04/20152015MarchApr-20154
      01/02/20162016FebruaryFeb-201613

       

      The MonthYearSeq starts at 1 for the earliest month in the calendar, and increments by 1 for each subsequent month.  I use this field in variables and set analysis to find the previous month (MonthYearSeq-1) and the same month in the previous year (MonthYearSeq-12) to the MonthYear that the user has selected.

       

      I would like to use the 'previous month' and 'same month in the previous year' in table headings by specifying the corresponding MonthYear to the MonthYearSeq derived by the variables.

       

      Is there a lookup function or similar that can be used in the UI?

       

      Thanks in advance.