Thanks Jon. Also if I put Max Rent Update date for the End Date parameter, I will get the date as when the rent was update? I will give this a try and let you know how it goes.
Thanks Jon. To add to this:
1) How to get the sum of the rows to show the total start rent, end rent and difference columns.
2) Create a new view to show the rent change quarterly and then total by quarter
propcode Rent Q1, Rent Q2, RentQ3 and Rent Q4