2 Replies Latest reply on Feb 17, 2016 11:03 AM by Robert Priewe

    Use calculated field to show items from specific period

    Robert Priewe

      Hello,

       

      ive got a question which is kind of hard to explain and can't figure out. Basically, I have data in this format:

      Customer #

      PeriodBalance

      Rating

      1Jan50Good
      1Feb40Medium
      2Feb60Medium
      3Jan35Medium
      3Feb30Bad
      4Jan40Medium
      4Feb38Good

       

      I want to show the balance for the period Jan using a calculated field. What I am doing is a calculated field saying

      IF([Period] = 'Jan') THEN [Balance] ELSE 0 END

      This works fine. However, I want to also add the Rating and always show the last available rating. In this case, the rating for period Feb and the balance for period Jan the way i've done it above.

       

      Is there any way to achieve this?


      Thanks,

      Robert