Forum Discussion
Lookup Max Value from another table while keeping Report Filter
Anonymous
You may create the following column in table 2, but there is not enough details in table 2, the unnecessary columns are important when you create the relationship between the two tables. Please add more to the table 2 sample. You should have a year column since you want to filter by year.
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
Anonymous
You may create the following column in table 2, but there is not enough details in table 2, the unnecessary columns are important when you create the relationship between the two tables. Please add more to the table 2 sample. You should have a year column since you want to filter by year.
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.