My data source have multiple years. I want to show latest year of data in one of the table in SSRS report.
When I tried to filter the table with First(field!year.value,"DataSource")
I am getting error message "Aggregate functions cannot be used in dataset filters or data region filters"