Forum Discussion
Lookup Max Value from another table while keeping Report Filter
Hello! I am trying to look up the maximum "utilization category" in Table 1 for each "item" and bring it into Table 2 as a calculated column to use as a slicer. The challenge I am running into is...
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 , how table 1 and table 2 are connected ??