Reflect changes in table


I need help with this in Tibco Spotfire 7.6

I have columns

[Name] [Manager] [Director] [Date]

Rahul     Rohit          Ravi          Jan-18

John      Jessica       Parul         Jan-18

Tj           Manu         Raghav      Feb-18

Rahul       Rohit        Rashid        Feb-18

John       Jessica      Parul          Feb-18


I want to display only those values in table visualization if Hierarchy of [Name] [Manager] [Director] changes or new is entered as compared to previous month.

 For this example, the result should be 

Tj         Manu     Raghav         Feb 18

Rahul   Rohit     Rashid         Feb-18

(2) Answers