Forum Discussion
Solved
Filter/Group Multiple Columns From Different Tables
I'm trying to show avg length, width and thickness by the item being face or a back in the matrix below. My problem is the length, width, and thickness values come from 3 different tables. Each of th...
Add a column to each table that defines what dimension it is (Length/Width/Thickness) and rename the (mm) column to a standard one across all 3 tables so that you can append them into a single table that looks more like this:
This will make building visuals significantly easier.
Here's an example of what each table looks like. This is the length table.