Forum Discussion
Getting a Distinct Avg from a separate table
I have two tables, one with number of units sold, and one with item cost. They are joined by the Item ID. The Inventory table has multiple rows with the items sold, so you would see a "Popco...
Hi Anonymous ,
You can try to change the relationship between tables to Both filtering.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.