7 Replies Latest reply on Jan 15, 2018 5:47 AM by Zhouyi Zhang

    Need to display the value if item exist in both yeard

    Lakshmi Palisetty

      Hi All,

       

      As per business requirement ,Yes should be displayed if the"Item" column value falling under both previous and current year (2016 and 2017) and NO should be displayed if the item column value falling under only in current year (2017).

       

      For Ex: In this case if you see Item nmber (4,2) YES should be displayed.

       

      NOTE: Here,The years(2016,2017) values are coming from the same column i.e "LAST UPDATE DATE"

       

      Please find the .twbx

       

      Thanks