Now I need to show the Revenue and the Rating in a report.
For this, I can logically write a case statement to show the rating. But this rating table keeps changing every 3 months.
So, I want to keep this as a separate lookup table in the database. Could someone please advice how to model this lookup table in RPD?