Not sure how to display this data in a pivot table

[makaveli80]

Hello everyone,

I have attached a spreadsheet, normally I know how to make pivot tables but in this case I'm not sure how to do it.

Y indicates that the block in the left column is applicable to the template

I don't understand how I can see things like overall completion per template, blocks per template, who the people are that are working on which block / template etc.

Do i have to redesign the table to make it work with a pivot?

Thanks in advance