Skip to main content

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:


Categories table:

Name | Other columns


People table:

People | Other columns


Capacity table:

People | Category 1 percentage | Category 2 percentage | Category 3 percentage | Category n percentage | Total capacity (sum)


How can I make this work?


Thanks!

I’m not sure I follow. Can you provide some screenshots?

I’m not sure I follow. Can you provide some screenshots?


Thanks ScottWorld


I want to create a table like this:


Where Person 1 and Person 2 are values linked from a people list table. And the column names Category 1, Category 2, Category 3, and Category 4 are linked from a category list table. The numeric values are percentages I will manually add in this table. Total would be a sum.

Thanks ScottWorld


I want to create a table like this:


Where Person 1 and Person 2 are values linked from a people list table. And the column names Category 1, Category 2, Category 3, and Category 4 are linked from a category list table. The numeric values are percentages I will manually add in this table. Total would be a sum.


Check out the Pivot Table Block.

Reply


Terms & Conditions