Hello, I have a table with a list of categories. Another one with a list of people.
I want to create a capacity table where I can have a percentage value for every category for each people. Ideally every other column will be linked to the categories tables. The layout will be like this:
Name | Other columns
People | Other columns
People | Category 1 percentage | Category 2 percentage | Category 3 percentage | Category n percentage | Total capacity (sum)
How can I make this work?