Getting latest record record over 4 dimentsions

[tkas]

I Have one requirement. I have data with latest Updated_date and latest Balance_Date over 4 dimensions. The requirement  is: first the user should select a date from Balance_Date and all the data should be less than or equal to the selected date. then the chart should show the latest records where Balance_date is equal to latest Balance_date and updated_date is equal to latest Updated_date. users selection is working , then taking only the latest records over those dimension is what need help. I tried to sketch this incase it helps to understand. any way to do this? thanks (edited)