I try to make a sample for your query..
What i understand from your question is that, when you select a year from the list box, you want to show the emp which are on that selected year and previous year of that selection.
for that purpose, i create two variables which are holding max(Year) and max(Year)-1. And by using the straight table, i write a set analysis to get the selected year and the previous year's list of employes.
I attach the document.
I hope, it will help you.
Community.qvw 149.5 K