Date and corrsponding value

Hi,

I have started using thoughtspot recently and I am unable to solve one problem. I have a column which has dates and the other column has corresponding values in amount($). I want only unique amount($) values irrespective of the date. As an eg. 

 

# job         Date      Amount

1                15/08/19   10    

1               16/08/19     10

1               17/08/19      10

1                19/08/19    5

 

I only want the dates 19/08 and amount 5 i.e the date when it was captured first and then  17/08  and 10 which is the date when there was a change in amount,

 

Could you please help me with this problem?

 

Thanks and Regards

2replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
Like Follow
  • Status Answered
  • 2 mths agoLast active
  • 2Replies
  • 37Views
  • 3 Following