I have register number, sale date, sale year, service year & service date of 1 million cars, My dimension is service year & I need 2 expressions,
1st expression must display distinct register number for service year
2nd expression is to find list of all register number sold in past 7 years for every corresponding service year(dimension)
Pls help