I have a report where I have KF like amount1, amount2, amount3 and total_amount. But I have a requirement that I need to show a comumn with a 'latest_year'. For example amount1 for 2003 and amount2 is 2004. If the Project has no data after 2003, it's latest_year would be 2003. and I need to have the 2003 in latest_year column with that project.
Does anyone has this situation..kindly give me how to solve this.