How to display the last value after the date ended?

[#1]

Good Morning,

I need help

I'm doing an application where I show product sales, customers pay the products over time to pay.

Example: the customer bought the product A on the date 01/05/2012 and the customer they give a period of 5 years to finish paying it until the date 01/05/2017.

So what the customer requests in your application is the total sum of the sales of your products, but if the date of the product A finished paying on 01/05/2017 then you want that when you select the product A me of the last value of Payment of the month 01/05/2017, then when I select the product A only gives me the date until the mentioned date and what the customer asks for when I select the dates after I finish their last payment for example: the product A I finish the 01/05/2017 but the client wants to select the month 01/06/2017 or 01/07/2017 or 01/08/2017 and to show him the last payment value that ended on 01/05/2017, how can I do That gives me the last value of my products by selecting the months after I have finished paying?

I have no idea that doing so

Thank you

[Anil_Babu_Samineni]

I afraid to read paragraphs, Can you please share sample data set and explain result set when selection happen on products. Perhaps this root may solve your solution